[GENERAL] Possible bug: could not open relation with OID [numbers]SQL State: XX000

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема [GENERAL] Possible bug: could not open relation with OID [numbers]SQL State: XX000
Дата
Msg-id CAMjNa7ckR8BAsW2Lu3VUSzTqY5SH0dprZU5=NH_nsHaJ_ynJ-g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000
Список 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

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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [GENERAL] explain analyze output: 0 rows, 1M loopa
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000