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

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000
Дата
Msg-id CAMjNa7eLii9EcuPERJoGGvUw7q+MDHd9B4SCNpXkf14662e+Tw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000  (Adam Brusselback <adambrusselback@gmail.com>)
Ответы Re: [GENERAL] Possible bug: could not open relation with OID [numbers] SQL State: XX000  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
Alright I figured it out.

The OID does not match any of the temp tables, so not sure what's up there.

I have the function RETURN QUERY,
and then I drop all my temp tables.

If I don't drop the tmp_base table at the end of the function, it will
work just fine.  If I keep the drop at the end in there, it'll blow up
every time.

This seriously seems like a bug to me.


-- 
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 по дате отправления:

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: [GENERAL] Possible bug: could not open relation with OID[numbers] SQL State: XX000
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Possible bug: could not open relation with OID [numbers] SQL State: XX000