| 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
| 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 |