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

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

From: bakkiya <bakkiya(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Could not open relation with OID (table partitioning issue?)
Date: 2010-11-19 14:17:17
Message-ID: 1290176237412-3272358.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

Responses

pgsql-novice by date

Next:From: markDate: 2010-11-20 03:45:05
Subject: Re: Could not open relation with OID (table partitioning issue?)
Previous:From: Tom LaneDate: 2010-11-18 15:36:21
Subject: Re: Debugging PostgreSql queries

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