Carlo Stonebanks <carlo@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: gsievers19@comcast.net
p: 305.321.1144
