Re: Delimited identifier length

Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Next question is do we want to change it?  I can't imagine any real good
>> use for a null-string name, but is there any risk of breaking existing
>> applications?

> I think the larger risk is breaking applications if we leave it this way.  

[... cogitates ...]  Yeah, you're probably right.  I agree with changing
it --- any other objectors out there?

> OTOH, I'd suggest that we do not enforce the 128 maximum length mandated
> by SQL. :-)

Check.  Not that I want to set NAMEDATALEN to 129, mind you ... but
I feel that *silent* truncation of overlength identifiers is good
programming language style.  At the moment I seem to be outvoted:

regression=# create table z1234567890123456789012345678901234567890 (f1 int);
NOTICE:  identifier "z1234567890123456789012345678901234567890" will be truncated to "z123456789012345678901234567890"
CREATE

but I will vote to remove that notice if it comes to a vote again.
        regards, tom lane