Skip site navigation (1) Skip section navigation (2)

Re: Could not open relation with OID (table partitioning issue?)

From: "mark" <dvlhntr(at)gmail(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'bakkiya'" <bakkiya(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Could not open relation with OID (table partitioning issue?)
Date: 2010-11-23 01:11:49
Message-ID: 004a01cb8aab$690bc1d0$3b234570$@com (view raw or flat)
Thread:
Lists: pgsql-novice
 

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Monday, November 22, 2010 8:10 AM
To: mark
Cc: 'bakkiya'; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Could not open relation with OID (table partitioning
issue?) 

>"mark" <dvlhntr(at)gmail(dot)com> writes:
>> I don't know if this is a bug and if so, if it fixed in the most current
>> patch. (I don't see anything in the release notes that make think so
though
>> however).

>At least one reason for this type of problem was fixed in 8.4.

>commit d4a363cdf2b426bbf6c401543b8286ad86ca9bd5
>Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>Date:   Tue May 12 03:11:02 2009 +0000

 >   Modify find_inheritance_children() and find_all_inheritors() to add the
 >   ability to lock relations as they scan pg_inherits, and to ignore any
 >   relations that have disappeared by the time we get lock on them.  This
 >   makes uses of these functions safe against concurrent DROP operations
 >   on child tables: we will effectively ignore any just-dropped child,
 >   rather than possibly throwing an error as in recent bug report from
 >   Thomas Johansson (and similar past complaints).  The behavior should
 >   not change otherwise, since the code was acquiring those same locks
 >   anyway, just a little bit later.
    
 >   An exception is LockTableCommand(), which is still behaving unsafely;
 >   but that seems to require some more discussion before we change it.

>			regards, tom lane




So is my adding a access exclusive lock to the parent table when dropping
children a bad thing (tm), in terms of introducing an error, since it uses
the locktablecommand()?

Still riding 8.3.7 here but wanted to keep this in mind for 9.0.1 and higher
when I migrate. 

Thanks 

-Mark



In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-11-23 01:41:24
Subject: Re: Could not open relation with OID (table partitioning issue?)
Previous:From: Josh KupershmidtDate: 2010-11-22 23:44:28
Subject: Re: Change Data Capture

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group