pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
sequence was re-created
2+ messages / 2 participants
[nested] [flat]

* sequence was re-created
@ 2002-07-17 10:19  peter@jingo.com
  0 siblings, 1 reply; 2+ messages in thread

From: peter@jingo.com @ 2002-07-17 10:19 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: sequence was re-created
@ 2002-07-19 00:37  Josh Berkus <josh@agliodbs.com>
  parent: peter@jingo.com
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2002-07-19 00:37 UTC (permalink / raw)
  To: peter@jingo.com; pgsql-php


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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-07-19 00:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-17 10:19 sequence was re-created peter@jingo.com
2002-07-19 00:37 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox