Re: Serial not so unique?

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