"Vitaliy V. Romanets" <vitaliy@gu.net> writes:
> I use 6.5.2 and C interface.
> When program has been run i've recieved the message:
> NOTICE: LockRelease: locktable lookup failed, no lock
> /*The part of code:*/
> PQexec(conn,"declare grh1 cursor for select x1 from test where x1='RRR'");
> res10=PQexec(conn,"fetch all in grh1");
> PQexec(conn,"close grh1");
> /*end_of_part*/
> The program runs well without this part.
Hmm, you are doing that inside a begin/end transaction block, right?
Not sure why you'd be seeing this notice from what appears to be valid
code.
6.5.2 is far enough back that I don't have a running copy to try to
reproduce this on. Please update to 7.0.3 and see if you still have
the problem; if so, I'll take more interest in it...
regards, tom lane