| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Identity columns should own only one sequence |
| Date: | 2019-04-24 14:48:25 |
| Message-ID: | fade6420b196fb47308da2e436050ad3e84719f4.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, 2019-04-14 at 20:15 +0200, I wrote:
> I wrote:
> > Identity columns don't work if they own more than one sequence.
>
> Alternatively, maybe getOwnedSequence should only consider sequences
> with an "internal" dependency on the column. That would avoid the problem
> without forbidding anything, since normal OWNED BY dependencies are "auto".
>
> What do you think?
Here is a patch that illustrates the second approach.
I'll add this thread to the next commitfest.
Yours,
Laurenz Albe
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Change-getOwnedSequence-to-only-find-sequences-for-i.patch | text/x-patch | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-04-24 15:30:06 | Re: Help to review the with X cursor option. |
| Previous Message | Antonin Houska | 2019-04-24 14:48:20 | Re: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3 |