Re: BUG #3668: type error in serial

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Weimer" <eweimer(at)thelocalphonecompany(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3668: type error in serial
Date: 2007-10-10 21:32:17
Message-ID: 24664.1192051937@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Eric Weimer" <eweimer(at)thelocalphonecompany(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-10-11 00:00:18 Re: BUG #3662: Seems that more than one run of a functions causes an error
Previous Message Tom Lane 2007-10-10 21:23:42 Re: BUG #3667: Job scheduling with Greenplum fails