On 2020-08-04 19:36, Konstantin Knizhnik wrote:
Yes, generated columns are also using implicitly generated sequences. So them are very similar with SERIAL/BIGSERIAL columns. This actually make we wonder why we can not handle them in the same way in CREATE TABLE LIKE.
The current specification of serial is a parse-time expansion of integer column, sequence, and column default. The behavior of column defaults in CREATE TABLE LIKE does not currently include rewriting the default expression or creating additional schema objects. If you want to introduce these concepts, it should be done in a general way, not just hard-coded for a particular case.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
