Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.6

Request #14262 Ability to change maximum length of sequences
Submitted: 2008-06-30 15:57 UTC
From: heinst Assigned: wiesemann
Status: Closed Package: DB_Table (version 1.5.5)
PHP Version: 5.2.6 OS: Irrelevant
Roadmaps: (Not assigned)    
Subscription  


 [2008-06-30 15:57 UTC] heinst (Bruno Souza)
Description: ------------ It would be interesting if we could define the maximum allowed sequence length instead of the default 26 chars (Specially if not using Oracle). I'm using postgres, and sometimes DB_Table nextId break on some long table names. Thank you.

Comments

 [2008-06-30 20:04 UTC] wiesemann (Mark Wiesemann)
You're not the first person that requests this change. The historic reason for these rather short sequence names is indeed Oracle with its 30 character limitation. DB_Table's goal is to provide a package that allows to be used with any of the supported DBMS. I can only think of a class property for disabling this limitation, defaulting to false, and with a big warning that the code might stop working if used with Oracle. Do you have another idea for the implementation of your request?
 [2008-07-09 03:21 UTC] heinst (Bruno Souza)
I agree completely with you! I think it would be a conditional define for this flag. The user define this constant before inclusion of the class or in a wrapper class.
 [2008-07-19 15:03 UTC] wiesemann (Mark Wiesemann)
Okay, thanks for your opinion. I'll try to work on this soon (hopefully until the end of the month).
 [2008-12-25 19:59 UTC] wiesemann (Mark Wiesemann)
Thank you for your bug report. This issue has been fixed in the latest released version of the package, which you can download at http://pear.php.net/get/DB_Table --- Sorry for the delay ...