Re: Sequences problem - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Sequences problem
Date
Msg-id 20070817214910.GE29125@phlogiston.dyndns.org
Whole thread Raw
In response to Sequences problem  (Judith <jaltamirano@correolux.com.mx>)
List pgsql-sql
On Fri, Aug 17, 2007 at 04:33:04PM -0500, Judith wrote:
> When I init a sesion with my db, if a do the next sentence:
> 
>    SELECT   currval('pagos_id_pago_seq');
> 
> 
> return this:
>   ERROR: the relation doesn't exist
>    (or somethimg like that, because the message is in spanish)

You _must_ call nextval() before a currval().  This is documented
behaviour.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


pgsql-sql by date:

Previous
From: Judith
Date:
Subject: Sequences problem
Next
From: "Scott Marlowe"
Date:
Subject: Re: Sequences problem