Postgres Pro
Downloads
Home   >   mailing lists

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

From bakkiya
Subject Re: Could not open relation with OID (table partitioning issue?)
Date
Msg-id 1290176237412-3272358.post@n5.nabble.com
Whole thread Raw
In response to Re: Could not open relation with OID (table partitioning issue?)  (peter@vfemail.net)
Responses Re: Could not open relation with OID (table partitioning issue?)  ("mark" <dvlhntr@gmail.com>)
List pgsql-novice
Tree view 
Hi.
We are also facing similar problem with postgresql partition tables. We are
querying 2 days old partition table and at the same time we are dropping 2
months old partition.Sometimes our queries are getting failed with "ERROR:
could not open relation with OID 1761740". We have set the constraint
exclusion to on. Can you please help us on resolving it?

Regards,
Bakki
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Could-not-open-relation-with-OID-table-partitioning-issue-tp3265708p3272358.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Debugging PostgreSql queries
Next
From: "mark"
Date:
Subject: Re: Could not open relation with OID (table partitioning issue?)