Re: Confusing behavior of create table like

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