On Mon, Aug 3, 2020 at 12:35 PM Peter Eisentraut <peter.eisentr...@2ndquadrant.com> wrote: > On 2020-08-03 14:58, Konstantin Knizhnik wrote: > > May be generated and identity columns are good things. I have nothing > > against them. > > But what preventing us from providing the similar behavior for > > serial/bigseries types? > > In my mind, serial/bigserial is deprecated and it's not worth spending > effort on patching them up. > > One thing we could do is change serial/bigserial to expand to identity > column definitions instead of the current behavior.
I'm not really convinced that's a good idea. There's probably a lot of people (me included) who are used to the way serial and bigserial work and wouldn't necessarily be happy about a change. Plus, aren't the generated columns still depending on an underlying sequence anyway? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
