Skip site navigation (1) Skip section navigation (2)

Feature request : Remove identifier length constraints

From: Thomas Swan <tswan(at)olemiss(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Feature request : Remove identifier length constraints
Date: 2001-06-01 15:15:42
Message-ID: 3B17B19E.3090309@olemiss.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
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?




Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-06-01 16:20:36
Subject: Re: Access statistics
Previous:From: Peter EisentrautDate: 2001-06-01 15:04:10
Subject: Re: Fw: Isn't pg_statistic a security hole - Solution Proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group