Postgres Pro
Downloads
Home   >   mailing lists

Re: Identity columns should own only one sequence - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Identity columns should own only one sequence
Date
Msg-id bfba098d-55bb-6a6d-013b-7c4235a60c15@2ndquadrant.com
Whole thread Raw
In response to Re: Identity columns should own only one sequence  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Identity columns should own only one sequence  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Tree view 
On 2019-04-29 18:28, Laurenz Albe wrote:
> I still think thatthat there is merit to Michael's idea of removing
> sequence "ownership" (which is just a dependency) when the DEFAULT
> on the column is dropped, but this approach is possibly cleaner.

I think the proper way to address this would be to create some kind of
dependency between the sequence and the default.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right?
Next
From: Tom Lane
Date:
Subject: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6