Re: identity columns

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: identity columns
Date: 2017-04-14 01:08:14
Message-ID: CAB7nPqTRuwadyG=f__KP5=Py-rEAYocWGVcECER0eLStG_1xOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 13, 2017 at 7:40 PM, Vitaly Burovoy
<vitaly(dot)burovoy(at)gmail(dot)com> wrote:
> On 4/6/17, Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com> wrote:
>> On 4/6/17, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>>> As I tried to mention earlier, it is very difficult to implement the IF
>>> NOT EXISTS behavior here, because we need to run the commands the create
>>> the sequence before we know whether we will need it.
>>
>> In fact with the function "get_attidentity" it is not so hard. Please,
>> find the patch attached.
> ...
>> I hope it is still possible to get rid of the "ADD GENERATED" syntax.
>
> Is it possible to commit the patch from the previous letter?
> It was sent before the feature freeze, introduces no new feature (only
> syntax change discussed in this thread and not implemented due to lack
> of a time of the author) and can be considered as a fix to the
> committed patch (similar to the second round in "sequence data type").

It seems to me that at least the part about removing ADD GENERATED
could be applied as an adjustment for the committed patch (INE would
be a new feature), and if there is a time to adjust already committed
features for the upcoming release, it is now. So I have added an open
item.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2017-04-14 01:31:20 Re: Declarative partitioning vs. information_schema
Previous Message Michael Paquier 2017-04-14 00:38:13 Re: Quorum commit for multiple synchronous replication.