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 :-) > 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 > -- Jerry Sievers Postgres DBA/Development Consulting e: gsievers19@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
