BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Date
Msg-id 152009601619.21242.262498029671910378@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15096
Logged by:          Evgeny
Email address:      evgeni-klimov@yandex.ru
PostgreSQL version: 10.2
Operating system:   Windows 7 x64
Description:

CREATE TABLE public.test (id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY
KEY, s TEXT);
CREATE TABLE public.test_copy (LIKE public.test INCLUDING ALL);
ERROR:  MINVALUE (1) must be less than MAXVALUE (-1)

However, if I change the id column type to INT, the second command
succeeds.
Checked on 10.3 and 10.2.


pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: TO_DATE Function unintended behavior when month value is greater than 12
Next
From: Tom Lane
Date:
Subject: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column