Re: Slony uninstall info/warning - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Slony uninstall info/warning
Date
Msg-id 20050311180850.GF26492@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Slony uninstall info/warning  (Christopher Browne <cbbrowne@acm.org>)
List 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@crankycanuck.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

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Best practices: Handling Daylight-saving time
Next
From: Steve Crawford
Date:
Subject: Re: Best practices: Handling Daylight-saving time