Sequences problem
| От | Judith |
|---|---|
| Тема | Sequences problem |
| Дата | |
| Msg-id | 46C61410.4070407@correolux.com.mx обсуждение исходный текст |
| Ответы |
Re: Sequences problem
Re: Sequences problem |
| Список | 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
В списке pgsql-sql по дате отправления: