REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)
Hi,
as the subjects reads I searched in the docs a way to instruct postgres
to create new sequences when copying tables containing serial columns,
but the resulting serial fields in the new tables reference the
original sequence.
Yes, there are workarounds, but having an option to make postgres
automatically
generate a new sequence for every serial field would be splendid.
I hope you will consider this feature for one of the future versions of
Postgres.
Thanks,
Nico
On Wed, Jul 18, 2007 at 03:10:30PM +0200, Nico Sabbi wrote:
Hi,
as the subjects reads I searched in the docs a way to instruct postgres
to create new sequences when copying tables containing serial columns,
but the resulting serial fields in the new tables reference the
original sequence.
That's the right behavior. You should be using
pg_get_serial_sequence('your_table','your_column')
to get the sequence name anyhow. :)
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate