Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id 5716B475B88
	for <pgsql-sql@postgresql.org>; Tue, 16 Jul 2002 23:48:28 -0400 (EDT)
Received: from oasis.net.au (guardian [210.8.139.5])
	by water.oasis.net.au (8.9.3/100.1) with ESMTP id OAA20622;
	Wed, 17 Jul 2002 14:02:34 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3D34E9B1.6000308@oasis.net.au>
Date: Wed, 17 Jul 2002 13:51:13 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1a+) Gecko/20020711
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sequence name length
References: <3D34D8B3.8060102@oasis.net.au> <10750.1026877256@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/255
X-Sequence-Number: 8633

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