Thread: What's it? "LockRelease:"

Hi All!
Sorry for my english.
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.


Thanks in advance

Vitaliy

"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