Sequences problem

From: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Sequences problem
Date: 2007-08-17 21:33:04
Message-ID: 46C61410.4070407@correolux.com.mx
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-08-17 21:49:10 Re: Sequences problem
Previous Message Franz Mühlbauer 2007-08-17 17:07:12 Limited number of polygon function arguments