On 03/31/2011 02:13 PM, Jerry Sievers wrote:
Carlo Stonebanks<carlo@xxxxxxxxxxxxx> writes:
Whenever I attempt to create a sequence whether this is done directly
via CREATE SEQUENCE or indrirectly vial declaring a column as SERIAL,
PG truncates it to 64 characters. Is this a documented limitation? I
cant find a reference to it. Is it possible to change this
limitation?
See the "name" data type.
As for enlarging it; I'll bet yes but you'll have to compile from source
to do this.
Someone on the hackers list can better explain :-)
See:
http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html
4.1.1. Identifiers and Key Words
Our table names are and fully descriptive, and our code depends on a
predictable sequence naming convention of the PG default
<table>_<column>_seq.
Yes, I know that its not a great idea to depend on consistent naming
conventions!
Carlo
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
