View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 12:10 PM
Tom Lane
 
Posts: n/a
Default Re: BUG #3668: type error in serial

"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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote