Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id BA7F1476E97
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 20:45:38 -0400 (EDT)
Received: from dilbert.nurseamerica.net (unknown [207.53.237.114])
	by postgresql.org (Postfix) with ESMTP id AFEB8476803
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 20:16:42 -0400 (EDT)
Received: from nurseamerica.net (archimedes.myrdin.net [206.176.158.41])
	by dilbert.nurseamerica.net (8.11.6/8.11.6) with ESMTP id g5J0Gcj26396;
	Tue, 18 Jun 2002 19:16:39 -0500
Message-ID: <3D0FCD63.8030505@nurseamerica.net>
Date: Tue, 18 Jun 2002 19:16:35 -0500
From: Kevin Brannen <kevinb@nurseamerica.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: is it easy to change the create sequence algorithm?
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200206/299
X-Sequence-Number: 8264

I see in the docs that when I create a column that is of type SERIAL, 
the engine automatically creates the sequence for me, named 
TABLE_COLUMN_seq.  That's great until the table name + column name 
lengths are > 27 chars, then it starts chopping, and you guessed it, I 
have multiple table/column combinations that don't differ until after 
that length.

Is there a way to influence the "create sequence" generator with a 
directive, hint, set value, whatever, to be something else?  (e.g. 
COLUMN_seq if I guarantee all the columns are unique)

Yes I know that I could create the sequence myself, but the engine does 
such a good job. :-)

Thanks,
Kevin