------=_Part_6447_25086152.1209422024794
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi all,
I am writing some code to get the current value of a sequence using the
currval function to use this value in a following insert on another table.
But I am having this message "currval of sequence "my_seq" is not yet
defined in this session".
Can someone explain me what is the problem with that and by the way
explain
me the definition of a session in postgres.
I have tried to avoid he problem using a stocked function and a trigger
but
I really want to avoid using triggers for debugging issues.
Thanks to all
Nacef
------=_Part_6447_25086152.1209422024794
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi all,<br><br>I am writing some code to get the current value of a
sequence using the currval function to use this value in a following
insert on another table. But I am having this message "currval of
sequence "my_seq" is not yet defined in this session".<br>
<br>Can someone explain me what is the problem with that and by the way
explain me the definition of a session in postgres.<br><br>I have tried to
avoid he problem using a stocked function and a trigger but I really want
to avoid using triggers for debugging issues.<br>
<br>Thanks to all<br><br>Nacef<br>
------=_Part_6447_25086152.1209422024794--
