Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id 9E625475C1F
	for <pgsql-sql@postgresql.org>; Tue, 16 Jul 2002 22:35:50 -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 MAA19197
	for <pgsql-sql@postgresql.org>; Wed, 17 Jul 2002 12:50:03 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3D34D8B3.8060102@oasis.net.au>
Date: Wed, 17 Jul 2002 12:38:43 +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: pgsql-sql@postgresql.org
Subject: Sequence name length
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/251
X-Sequence-Number: 8629

Hi,

Just a quick one on the length of the name of a sequence.

I have some table with long(ish) names like :     eselect_maincategory
The primary key is named :     maincat_id

When I create the table the sequence sql  looks like     
nextval('"eselect_maincategory_maincat_id_seq"'::text)

However the sequence created is named :     
eselect_maincategory_maincat_id     ( the '_seq' is lopped off )

This looke like a max of 31 characters.

Is a sequence name length limited to 31 characters or is it the tool I'm 
using - phpPgAdmin, I wonder ?

Your time and thoughts are very much appreciated.
Thank you.
Rudi Starcevic.