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