Re: What's it? "LockRelease:"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vitaliy V(dot) Romanets" <vitaliy(at)gu(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What's it? "LockRelease:"
Date: 2001-01-11 19:25:33
Message-ID: 12293.979241133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vitaliy V. Romanets" <vitaliy(at)gu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-11 19:46:02 Re: access checking using sql in 7.1beta3
Previous Message Mark Lane 2001-01-11 19:20:30 postmaster won't run