REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)

From: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)
Date: 2007-07-18 13:10:30
Message-ID: 469E1146.6010309@officinedigitali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nico Sabbi 2007-07-18 14:06:38 Can't SELECT from (INSERT ... RETURNING)
Previous Message Dimitri Fontaine 2007-07-18 12:34:52 Re: multirow insert