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

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Дата
Msg-id 87po4lkkaj.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn
Список pgsql-bugs
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 >> ERROR:  MINVALUE (1) must be less than MAXVALUE (-1)

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

The Value node's "ival" field is declared as a long.

sequence_options thinks it can put all the sequence parameters through
makeInteger and have them come out intact.

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: BUG #15067: Documentation or behaviour bug with autovacuumthresholds?
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15097: pgadmin3 tabs not properly themed with wxGTK3