Re: Sequence names have 64 character limit?

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