| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>, "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Column with recycled sequence value |
| Date: | 2005-01-13 21:19:03 |
| Message-ID: | 20050113211903.GA41687@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Jan 13, 2005 at 02:48:47PM -0600, Scott Marlowe wrote:
> On Thu, 2005-01-13 at 11:08, KÖPFERL Robert wrote:
> > suppose I have a let's say heavy used table. There's a column containing
> > UNIQUE in4
> > values. The data type musn't exceed 32-Bit. Since however the table is heavy
> > used 2^32 will be reached soon and then? There are far less than 4G-records
> > saved thus these values may be reused. How can this be accomplished?
> >
> > I already defined a sequence but then?
>
> Redefine it as a bigserial?
That would violate the 32-bit requirement since bigserial would
make the field a bigint (64 bits). Or am I missing something?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-01-13 21:31:54 | Re: Column with recycled sequence value |
| Previous Message | Scott Marlowe | 2005-01-13 20:48:47 | Re: Column with recycled sequence value |