Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
currval of sequence "my_seq" is not yet defined in this session
- From: "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: currval of sequence "my_seq" is not yet defined in this session
- Date: Tue, 29 Apr 2008 00:33:44 +0200
- Message-id: <f16f7ea00804281533w6bf6ba3ahd4068c8e691ad2cb(at)mail(dot)gmail(dot)com>
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
- Follow-Ups:
- Re: currval of sequence "my_seq" is not yet defined in this session
- From: Scott Marlowe
- Re: currval of sequence "my_seq" is not yet defined in this session
- Prev by Date: information_schema.referential_constraints permissions
- Next by Date: Truncate table at a certain size.
- Previous by thread: information_schema.referential_constraints permissions
- Next by thread: Re: currval of sequence "my_seq" is not yet defined in this session
- Indexes: