Re: BUG #3668: type error in serial - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3668: type error in serial
Date
Msg-id 24664.1192051937@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3668: type error in serial  ("Eric Weimer" <eweimer@thelocalphonecompany.net>)
Responses Re: BUG #3668: type error in serial
List pgsql-bugs
"Eric Weimer" <eweimer@thelocalphonecompany.net> writes:
> Creating a table with a column of type serial causes the creation of a
> sequence tied as the default value for the column.
> The actual type of the column is integer, however the sequence created is of
> type bigint. If the sequence is created as a bigint, then the column should
> also be defined as bigint.

This is not a bug, primarily because we have only one size of sequence.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3667: Job scheduling with Greenplum fails
Next
From: "Roberts, Jon"
Date:
Subject: Re: BUG #3667: Job scheduling with Greenplum fails