Re: Slony uninstall info/warning

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Slony uninstall info/warning
Date: 2005-03-11 18:08:50
Message-ID: 20050311180850.GF26492@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 15, 2005 at 02:00:20PM -0500, Christopher Browne wrote:
> As has been noted by others, this is an artifact of the JDBC driver
> holding onto a stored query plan. And it's somewhat worth noting that
> this is not unique to Slony-I...

(Yes, I'm behind on reading mail lists.)

Actually, I don't think this _is_ a JDBC issue. AIUI, The problem
bites you with Slony because its triggers use SPI. So the reference
to the oid is to the trigger's oid, which you won't lose until the
back ends are all recyled.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2005-03-11 18:22:06 Re: Best practices: Handling Daylight-saving time
Previous Message Brian Gunning 2005-03-11 17:52:28 Re: [JDBC] MS Access to PostgreSQL