| From: | Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au> |
|---|---|
| To: | Justin Clift <justin(at)postgresql(dot)org> |
| Cc: | Joe Conway <joseph(dot)conway(at)home(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Serial not so unique? |
| Date: | 2001-08-19 03:51:44 |
| Message-ID: | 20010819135144.H16924@sunhill.commsecure.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Aug 19, 2001 at 01:23:13PM +1000, Justin Clift wrote:
> Hmmm...
>
> Well, that would be a
>
> CREATE SEQUENCE foo_seq START 1 MINVALUE 4 MAXVALUE 101 CYCLE
>
> Still, that's not helpful. :(
>
> Is there any chance that the application created the sequence, or that
> someone created it manually?
Nope, the table was created fresh from its schema.
> Then again, you showed us the values the sequence was using, and they
> definitely weren't like the ones the sequence up there would create.
>
> Out of curiosity, which version of PostgreSQL are you using?
> 7.1.2/7.1.3?
7.1.2 on RH 7.1.
>
> Regards and best wishes,
>
> Justin Clift
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Corey Minter | 2001-08-19 07:52:31 | database corruption on VACUUM ANALYZE, now unable to initdb |
| Previous Message | Stephen Robert Norris | 2001-08-19 03:51:38 | Re: Serial not so unique? |