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?




Fri, 01 Jun 2001 10:15:42 -0500
Thomas Swan <tswan@olemiss.edu>
Feature request : Remove identifier length constraints
> 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


Wed, 6 Jun 2001 09:58:05 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
RE: Feature request : Remove identifier length constraints