Postgres Pro
Downloads
Home   >   mailing lists

Thread: ERROR: could not open relation with OID

ERROR: could not open relation with OID

From
bakkiya raj
Date:
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

Re: ERROR: could not open relation with OID

From
"Kevin Grittner"
Date:
bakkiya raj  wrote:

> 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.

You've not provided much information.  Please review this page and
follow up:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin