Re: Confusing behavior of create table like

On 2020-08-01 00:06, Konstantin Knizhnik wrote:
> Postgres provides serial and bigserial column types for which it
> implicitly creates sequence.
> As far as this mechanism is somehow hidden from user, it may be
> confusing that table
> created with CREATE TABLE LIKE has no associated sequence.

That's why identity columns were added.  You shouldn't use serial 
columns anymore, especially if you are concerned about behaviors like this.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services