Re: Could not open relation with OID (table partitioning issue?) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Could not open relation with OID (table partitioning issue?)
Date
Msg-id 22944.1290476484@sss.pgh.pa.us
Whole thread Raw
In response to Re: Could not open relation with OID (table partitioning issue?)  ("mark" <dvlhntr@gmail.com>)
Responses Re: Could not open relation with OID (table partitioning issue?)  (bakkiya <bakkiya@gmail.com>)
List pgsql-novice
"mark" <dvlhntr@gmail.com> writes:
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>>> An exception is LockTableCommand(), which is still behaving unsafely;
>>> but that seems to require some more discussion before we change it.

> 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()?

No; in 8.3 it's all right.  That comment was about the then
development-tip behavior of LOCK TABLE in 8.4, which would try to
recurse to child tables.  8.3 doesn't do that, it just locks exactly the
table you specify, so it won't fail unless you're dropping and
recreating the parent too...

            regards, tom lane

pgsql-novice by date:

Previous
From: "mark"
Date:
Subject: Re: Could not open relation with OID (table partitioning issue?)
Next
From: Machiel Richards
Date:
Subject: Postgresql on windows / solid state