Skip site navigation (1) Skip section navigation (2)

Re: dangling lock information?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dangling lock information?
Date: 2005-08-29 11:09:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hannu Krosing wrote:

>On P, 2005-08-28 at 22:23 +0200, Andreas Pflug wrote:
>>I'm currently testing pgAdmin support for slony, on pgsql CVS HEAD, and 
>>encounter strange problems from time to time.
>>After dropping and recreating the slony schema, all changes committed 
>>and all backends in <IDLE> state, I'm getting
>>"relation with OID xxx does not exist" when I'm trying to add a path. 
>>This seems to be triggered inside slony functions when a
>>    LOCK _test.pg_config IN EXCLUSIVE MODE
>>is performed.
>>The problem is gone as soon as I close the connection I've been using 
>>for prior schema changes, and use a fresh connection.
>>Does this description ring a bell for somebody?
>seems like the usual "pl/pgsql caches query plans and relation
>referenced inside the cached plan is gone" thing
Kind of, but the complete schema including procedures was dropped, so 
apparently after recreation the old plans were reused?!?


In response to


pgsql-hackers by date

Next:From: Knut P LehreDate: 2005-08-29 11:30:34
Subject: Re: SSL client crt verification
Previous:From: Jochem van DietenDate: 2005-08-29 10:10:06
Subject: Re: Call for 7.5 feature completion

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group