Postgres Pro
Downloads
Home   >   mailing lists

Re: sequence was re-created - Mailing list pgsql-php

From Josh Berkus
Subject Re: sequence was re-created
Date
Msg-id 200207181737.26875.josh@agliodbs.com
Whole thread Raw
In response to sequence was re-created  (<peter@jingo.com>)
List pgsql-php
Tree view 
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

pgsql-php by date:

Previous
From:
Date:
Subject: sequence was re-created
Next
From: "Peter"
Date:
Subject: Problem Interval() and Timestamp() with Postgres 7.21