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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to