currval of sequence "my_seq" is not yet defined in this session - Mailing list pgsql-sql

From Nacef LABIDI
Subject currval of sequence "my_seq" is not yet defined in this session
Date
Msg-id f16f7ea00804281533w6bf6ba3ahd4068c8e691ad2cb@mail.gmail.com
Whole thread Raw
Responses Re: currval of sequence "my_seq" is not yet defined in this session  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: "Lodewijk Voege"
Date:
Subject: information_schema.referential_constraints permissions
Next
From: Dana Huggard - Navarik
Date:
Subject: Truncate table at a certain size.