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