Thread: sequence was re-created

sequence was re-created

From
Date:
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


Re: sequence was re-created

From
Josh Berkus
Date:
Peter,

> NOTICE:  billing_requests_id_seq.nextval: sequence was re-created
>
> 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
the output of the PSQL command
\d billing_requests_id_seq

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco