Rudi Starcevic <rudi(at)oasis(dot)net(dot)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