currval of sequence "my_seq" is not yet defined in this session

Поиск
Список
Период
Сортировка
От Nacef LABIDI
Тема currval of sequence "my_seq" is not yet defined in this session
Дата
Msg-id f16f7ea00804281533w6bf6ba3ahd4068c8e691ad2cb@mail.gmail.com
обсуждение исходный текст
Ответы Re: currval of sequence "my_seq" is not yet defined in this session  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-sql
Hi all,<br /><br />I am writing some code to get the current value of a sequence using the currval function to use this
valuein a following insert on another table. But I am having this message "currval of sequence "my_seq" is not yet
definedin this session".<br /><br />Can someone explain me what is the problem with that and by the way explain me the
definitionof a session in postgres.<br /><br />I have tried to avoid he problem using a stocked function and a trigger
butI really want to avoid using triggers for debugging issues.<br /><br />Thanks to all<br /><br />Nacef<br /> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Lodewijk Voege"
Дата:
Сообщение: information_schema.referential_constraints permissions
Следующее
От: Dana Huggard - Navarik
Дата:
Сообщение: Truncate table at a certain size.