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.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services