From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | srn(at)commsecure(dot)com(dot)au |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Serial not so unique? |
Date: | 2001-08-18 14:40:33 |
Message-ID: | 10910.998145633@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au> writes:
> On investigation, it seems that the serial number has got to 101, then
> set itself back to 4, causing nextval to return 5, and there are already
> entries from 1-101.
Never heard of such misbehavior before. What PG version are you
running? Any chance of providing a reproducible example?
> Has anyone seen anything like this? I can work around it by generating
> a serial number within the application, but that's not ideal.
Frankly, I suspect that the problem *is* in your application. Sequences
are completely reliable in everyone else's experience... they've got
documented shortcomings like leaving "holes" in their output, but they
don't generate the same nextval() multiple times.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2001-08-18 14:47:00 | Re: Installing Postrgesql 7.1.2-3 |
Previous Message | Joe Conway | 2001-08-18 13:17:17 | Re: Serial not so unique? |