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

From Laurenz Albe
Subject Re: Identity columns should own only one sequence
Date
Msg-id 3421a0c6ccffda1da75b0a81c8011bb6e7dccbf8.camel@cybertec.at
Whole thread Raw
In response to Re: Identity columns should own only one sequence  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Identity columns should own only one sequence  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Thu, 2019-05-02 at 22:43 +0200, Peter Eisentraut wrote:
> 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.

That is certainly true.  But that's hard to retrofit into existing databases,
so it would probably be a modification that is not backpatchable.

Yours,
Laurenz Albe




pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: Unhappy about API changes in the no-fsm-for-small-rels patch
Next
From: Peter Eisentraut
Date:
Subject: Re: Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right?