| From: | Adam Brusselback <adambrusselback(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Possible bug: could not open relation with OID [numbers] SQL State: XX000 |
| Date: | 2017-11-01 20:11:07 |
| Message-ID: | CAMjNa7ckR8BAsW2Lu3VUSzTqY5SH0dprZU5=NH_nsHaJ_ynJ-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| Attachment | Content-Type | Size |
|---|---|---|
| function.sql | text/plain | 9.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2017-11-01 22:03:54 | Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 |
| Previous Message | Scott Marlowe | 2017-11-01 19:48:03 | Re: explain analyze output: 0 rows, 1M loopa |