| From: | Hannu Krosing <hannu(at)skype(dot)net> |
|---|---|
| To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: dangling lock information? |
| Date: | 2005-08-29 10:05:55 |
| Message-ID: | 1125309955.4897.5.camel@fuji.krosing.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
--
Hannu Krosing <hannu(at)skype(dot)net>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jochem van Dieten | 2005-08-29 10:10:06 | Re: Call for 7.5 feature completion |
| Previous Message | Harald Fuchs | 2005-08-29 07:56:44 | Re: Call for 7.5 feature completion |