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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Дата
Msg-id 152009601619.21242.262498029671910378@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Список 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 по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: TO_DATE Function unintended behavior when month value is greater than 12
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column