Nathan Myers writes:
> We have noticed here also that object (e.g. table) names get truncated
> in some places and not others. If you create a table with a long name,
> PG truncates the name and creates a table with the shorter name; but
> if you refer to the table by the same long name, PG reports an error.
This seems odd, because the truncation happens in the scanner. Care to
provide a test case?
> (Very long names may show up in machine- generated schemas.) Would
> patches for this, e.g. to refuse to create a table with an impossible
> name, be welcome?
Tom Lane is opposed to this, although a number of people seem to like it.
Sounds like a configuration option to me.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/