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

From Andrew Gierth
Subject Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Date
Msg-id 87po4lkkaj.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn  (Michael Paquier <michael@paquier.xyz>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: BUG #15067: Documentation or behaviour bug with autovacuumthresholds?
Next
From: PG Bug reporting form
Date:
Subject: BUG #15097: pgadmin3 tabs not properly themed with wxGTK3