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

From Tom Lane
Subject Re: update before drop causes OID problems in transaction?
Date
Msg-id 10754.1142635969@sss.pgh.pa.us
Whole thread Raw
In response to update before drop causes OID problems in transaction?  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: update before drop causes OID problems in transaction?
List pgsql-sql
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.
        regards, tom lane


pgsql-sql by date:

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