Thread

1. Feature request : Remove identifier length constraints

   Thomas Swan <tswan@olemiss.edu> — 2001-06-01T15:15:42Z

   I just got bit by the identifier name is too long and will be truncated 
   limitation in Postgresql.
   
   AFIAA there is a limit of 64 characters for identifiers (names of 
   tables, sequences, indexes, etc...)
   
   I had just started to get in the habit of using serial data types until 
   I made to tables with long names and the automatic sequence names that 
   were generated conflicted, *ouch* ...
   
   Is there the possibility of a name conflict resolution during the table 
   creation phase similar to "the name I want to assign is already taken, 
   so I'll pick a different name..." on the serial data type?
   
   
   
   
   

2. RE: Feature request : Remove identifier length constraints

   Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2001-06-06T01:58:05Z

   > I had just started to get in the habit of using serial data types until
   > I made to tables with long names and the automatic sequence names that
   > were generated conflicted, *ouch* ...
   >
   > Is there the possibility of a name conflict resolution during the table
   > creation phase similar to "the name I want to assign is already taken,
   > so I'll pick a different name..." on the serial data type?
   
   I'll have a look, but it'll be a few weeks before I have a patch for it (as
   I'm doing other things at the moment)
   
   Chris