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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Дата
Msg-id 31194.1520098424@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Список pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> 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)

Hm ... works fine for me on a 64-bit Linux machine ... but it fails
as described on 32-bit.  Something in the LIKE code path is shoving
the sequence's maxvalue through a variable with platform-dependent
width, probably of type "long".  No time right now to locate the
exact problem.

            regards, tom lane


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: BUG #15067: Documentation or behaviour bug with autovacuumthresholds?