Re: is it easy to change the create sequence algorithm?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Kevin Brannen <kevinb(at)nurseamerica(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: is it easy to change the create sequence algorithm?
Date: 2002-06-21 20:43:22
Message-ID: web-1552196@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Hammond 2002-06-21 21:34:59 Re: is it easy to change the create sequence algorithm?
Previous Message Dirk Lutzebaeck 2002-06-21 20:32:58 Can somebody help me to optimize this huge query?