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

From Josh Berkus
Subject Re: is it easy to change the create sequence algorithm?
Date
Msg-id web-1552196@davinci.ethosmedia.com
Whole thread Raw
In response to is it easy to change the create sequence algorithm?  (Kevin Brannen <kevinb@nurseamerica.net>)
List pgsql-sql
Kevin,

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

This would require hacking the Postgres source code.

Sure you don't wanna just create the sequences manually?

If you're sure, post your question to psql-Hackers to find out where
the SERIAL code is located.

-Josh


pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Can somebody help me to optimize this huge query?
Next
From: Andrew Hammond
Date:
Subject: Re: is it easy to change the create sequence algorithm?