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