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