| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Identity columns should own only one sequence |
| Date: | 2019-04-27 12:16:01 |
| Message-ID: | 9b31f658-b841-fa86-b9b1-e7329bd3a64d@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2019-04-26 15:37, Laurenz Albe wrote:
> What do you think of the patch I just posted on this thread to
> remove ownership automatically when the default is dropped, as Michael
> suggested? I think that would make things much more intuitive from
> the user's perspective.
I think that adds more nonstandard behavior on top of an already
confusing and obsolescent feature, so I can't get too excited about it.
A more forward-looking fix would be your other idea of having
getOwnedSequence() only deal with identity sequences (not serial
sequences). See attached patch for a draft.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Untangle-some-stuff-about-identity-sequences.patch | text/plain | 6.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2019-04-27 13:30:37 | Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| Previous Message | Bruce Momjian | 2019-04-27 11:40:49 | Re: Optimizer items in the release notes |