BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: evgeni-klimov(at)yandex(dot)ru
Subject: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Date: 2018-03-03 16:53:36
Message-ID: 152009601619.21242.262498029671910378@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15096
Logged by: Evgeny
Email address: evgeni-klimov(at)yandex(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-03-03 17:33:44 Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Previous Message Andrew Gierth 2018-03-02 20:51:43 Re: TO_DATE Function unintended behavior when month value is greater than 12