Message-ID: <46C61410.4070407@correolux.com.mx>
Date: Fri, 17 Aug 2007 16:33:04 -0500
From: Judith <jaltamirano@correolux.com.mx>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Sequences problem
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello everybody, I have a question related with sequences.............

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)

but if I do first,

    SELECT nextval('pagos_id_pago_seq');

and then
    SELECT currval('pagos_id_pago_seq');   it success, returns the 
current sequence value,  it is possible to indicate that the sequence is 
already started and in the value 4567 but I need first to now the 
current value before the next, how can I do?

    Thanks in advanced