On Thursday, January 24, 2002, at 06:53 , Tom Lane wrote:
> BTW, I noticed the other day that both SQL92 and SQL99 specify the
> maximum identifier length as 128. So really there is a standardization
> argument for pushing it up to 128 ...
Yeah, I realize this was a month ago. :)
One question: What is an identifier defined as? The reason I'm being
pendantic is that I've run into trouble not with any particular table or
column name being > 32, but the automated key name generated for tables
with a NOT NULL UNIQUE column is table_column_key, which easily busts
the limit.
The reason I ask is because if an identifier is only defined as
something like a column name or table name, then NAMEDATALEN would have
to be 128+128+5, if I did the math right.
BTW, I keep my patch for configuring it in 7.1 at:
http://www.zettabyte.net/downloads/postgres/namedatalen-patch/
in case anyone needs it.
-Bill
