[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] Bug fix confirmation: could not open relation with OID nnn
From:       Bruce Momjian <bruce () momjian ! us>
Date:       2014-07-30 17:48:43
Message-ID: 20140730174843.GJ2791 () momjian ! us
[Download RAW message or body]

On Thu, Jul 10, 2014 at 02:21:57PM +0300, Aryeh Leib Taurog wrote:
> I'd like to do the following for large frequent updates on central 
> table with ~1m rows:
> 
> 1. Create new table like original
> 2. Populate new table
> 3. DROP original table
> 4. RENAME new table to original
> 
> Some testing revealed that in pg 8.4 and 9.1, if another session 
> queries the table between 3 and 4, the query fails with error 'could 
> not open relation with OID nnn.'  In pg 9.3 there's no error.
> <https://gist.github.com/altaurog/ab0019837719d2a93e6b>
> 
> This seems to be the topic of conversation here:
> <http://www.postgresql.org/message-id/flat/12791.1310599941@sss.pgh.pa.us#12791.1310599941@sss.pgh.pa.us>
>  <http://www.postgresql.org/message-id/flat/20285.1340769074@sss.pgh.pa.us#20285.1340769074@sss.pgh.pa.us>
>  
> Do I correctly infer that the change in behavior was an intentional 
> fix and that with pg >= 9.3 I can rely on the above method working 
> without any risk of this error in my queries?

Yes, I think so.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[prev in list] [next in list] [prev in thread] [next in thread]