Re: Delimited identifier length

Peter Eisentraut <peter_e(at)gmx(dot)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