Carlo Stonebanks <ca...@stonebanks.ca> 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: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
