Re: Sequence name length

Rudi Starcevic <rudi@oasis.net.au> writes:
> Just a quick one on the length of the name of a sequence.
> ...
> However the sequence created is named :     
> eselect_maincategory_maincat_id     ( the '_seq' is lopped off )

What version are you running?  Anything recent will keep the '_seq'
and lop elsewhere.

> This looke like a max of 31 characters.

Yeah, the default NAMEDATALEN is 32, allowing for 31 chars plus a
terminating null.  You can build a private version with larger
NAMEDATALEN, and there are recurring discussions about increasing
the default length.
        regards, tom lane