sequence was re-created

sequence was re-created

am 17.07.2002 12:19:36 von Peter

What would create this notice in the php log:

NOTICE: billing_requests_id_seq.nextval: sequence was re-created

I'm performing the query:
select nextval('billing_requests_id_seq') as nextid;

What does it mean "sequence be re-created"?

Thanks for any help.
Peter


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: sequence was re-created

am 19.07.2002 02:37:26 von Josh Berkus

Peter,

> NOTICE: billing_requests_id_seq.nextval: sequence was re-created
>=20
> I'm performing the query:
> select nextval('billing_requests_id_seq') as nextid;

That's really odd. Can you post the version of Postgres you are running, =
and=20
the output of the PSQL command
\d billing_requests_id_seq

--=20
-Josh Berkus
Aglio Database Solutions
San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html