Re: Sequence name length

Hi Tom,

Here is the output from 'select version()'

PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2

Cheers
Rudi.

Tom Lane wrote:

>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
>
>
>