On 4/7/17 01:26, Vitaly Burovoy wrote: > I've implement SET GENERATED ... IF NOT EXISTS. It must be placed > before other SET options but fortunately it conforms with the > standard. > Since that form always changes the sequence behind the column, I > decided to explicitly write "[NO] CACHE" in pg_dump. > > As a plus now it is possible to rename the sequence behind the column > by specifying SEQUENCE NAME in SET GENERATED. > > I hope it is still possible to get rid of the "ADD GENERATED" syntax.
I am still not fond of this change. There is precedent all over the place for having separate commands for creating a structure, changing a structure, and removing a structure. I don't understand what the problem with that is. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers