REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE) - Mailing list pgsql-general

From Nico Sabbi
Subject REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)
Date
Msg-id 469E1146.6010309@officinedigitali.it
Whole thread Raw
Responses Re: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)  (David Fetter <david@fetter.org>)
List 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

pgsql-general by date:

Previous
From: Frank van Vugt
Date:
Subject: it works, but is it legal to separate schema/table/field references using spaces
Next
From: Nico Sabbi
Date:
Subject: Can't SELECT from (INSERT ... RETURNING)