Re: update before drop causes OID problems in transaction? - Mailing list pgsql-sql

From Jeff Frost
Subject Re: update before drop causes OID problems in transaction?
Date
Msg-id Pine.LNX.4.64.0603171454170.11424@discord.dyndns.org
Whole thread Raw
In response to Re: update before drop causes OID problems in transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: update before drop causes OID problems in transaction?
List pgsql-sql
On Fri, 17 Mar 2006, Tom Lane wrote:

> Jeff Frost <jeff@frostconsultingllc.com> writes:
>> After commit, I get a lovely:
>>   ERROR:  could not open relation with OID x
>
> Could we see a complete test case, rather than handwaving?  I'd expect
> some issues like this if you were using any prepared statements or
> plpgsql functions with non-EXECUTEd queries involving the dropped table,
> but your description doesn't mention either of those risk factors.

Tom, it's for a client, so let me see if they'll allow me to post the 
transaction, if not, I'll have to write something equivalent.  More later.


-- 
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: update before drop causes OID problems in transaction?
Next
From: Jeff Frost
Date:
Subject: Re: update before drop causes OID problems in transaction?