Feature request : Remove identifier length constraints

Started by Thomas Swanover 24 years ago2 messages
#1Thomas Swan
tswan@olemiss.edu

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?

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Thomas Swan (#1)
RE: 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