Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Possible bug: could not open relation with OID [numbers]SQL State: XX000 - Mailing list pgsql-general

From Adam Brusselback
Subject [GENERAL] Possible bug: could not open relation with OID [numbers]SQL State: XX000
Date
Msg-id CAMjNa7ckR8BAsW2Lu3VUSzTqY5SH0dprZU5=NH_nsHaJ_ynJ-g@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Tree view 
Hey all,
First off: PostgreSQL 10.0 on x86_64-pc-linux-gnu, compiled by gcc
(Debian 6.3.0-18) 6.3.0 20170516, 64-bit

I have something going on, and i'm not sure what is causing it.  I
recently upgraded our development environment to PG10, and the error
in the subject appeared with one of my analytical functions.

It creates some temporary tables, joins them together, and then spits
out a result.  If I run it for one "contract_id", it'll work just
fine, then I run it for another similar "contract_id", it'll throw the
error in the subject.

I attached the function.

Any help would be appreciated.
Thanks,
-Adam

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Attachment

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] explain analyze output: 0 rows, 1M loopa
Next
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000