Re: Truncation of char, varchar types - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Truncation of char, varchar types
Date
Msg-id Pine.LNX.4.30.0104101904050.1403-100000@peter.localdomain
Whole thread Raw
In response to Re: Truncation of char, varchar types  (ncm@zembu.com (Nathan Myers))
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: libpq PQexec call of COPY
Next
From: The Hermit Hacker
Date:
Subject: Going from 7.0.3 -> 7.1 ...