ERROR: could not open relation with OID

From: bakkiya raj <bakkiya(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: could not open relation with OID
Date: 2010-11-19 12:47:09
Message-ID: AANLkTimqhW0RtJA_Ctdn-P8R9RZ5D6OjY=gpfw4hWu8D@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
We are facing a 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 us on fixing this.

Regards,
Bakki

Browse pgsql-admin by date

  From Date Subject
Next Message Florian Weimer 2010-11-19 13:01:43 Re: Pre-Allocate tablespace on disk
Previous Message Tom Lane 2010-11-18 18:04:13 Re: 8.4 process killed- what sort of recovery options do I have?