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 81a363d742245454ed7dea745d1099be4eb9fea5.camel@cybertec.at
Whole thread Raw
In response to Re: Identity columns should own only one sequence  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Peter Eisentraut wrote:
> On 2019-05-08 16:49, Laurenz Albe wrote:
> > I believe we should have both:
> > 
> > - Identity columns should only use sequences with an INTERNAL dependency,
> >   as in Peter's patch.
> 
> I have committed this.

Thanks!

> > - When a column default is dropped, remove all dependencies between the
> >   column and sequences.
> 
> There is no proposed patch for this, AFAICT.

There was one in
https://www.postgresql.org/message-id/3916586ef7f33948235fe60f54a3750046f5d940.camel%40cybertec.at

> So I have closed this commit fest item for now.

That's fine with me.

Yours,
Laurenz Albe




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: POC: Cleaning up orphaned files using undo logs
Next
From: Andrey Lepikhov
Date:
Subject: Re: Removing unneeded self joins