Thread: Feature request : Remove identifier length constraints

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?

> 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