is it easy to change the create sequence algorithm? - Mailing list pgsql-sql

From Kevin Brannen
Subject is it easy to change the create sequence algorithm?
Date
Msg-id 3D0FCD63.8030505@nurseamerica.net
Whole thread Raw
Responses Re: is it easy to change the create sequence algorithm?
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Janning Vygen
Date:
Subject: Re: Joining three data sources.
Next
From: Jean-Luc Lachance
Date:
Subject: Re: SQL Challenge: Skip Weekends