From: Josh Berkus <josh@agliodbs.com>
To: Kevin Brannen <kevinb@nurseamerica.net>
To: pgsql-sql@postgresql.org
Subject: Re: is it easy to change the create sequence algorithm?
Date: Fri, 21 Jun 2002 13:43:22 -0700
Message-ID: <web-1552196@davinci.ethosmedia.com> (raw)
In-Reply-To: <3D0FCD63.8030505@nurseamerica.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, kevinb@nurseamerica.net
Subject: Re: is it easy to change the create sequence algorithm?
In-Reply-To: <web-1552196@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox