Re: ERROR: could not open relation with OID

On 04/22/2015 02:37 PM, Steve Crawford wrote:
> On 04/22/2015 01:25 PM, Adrian Klaver wrote:
>>
>>> If it is of importance, it appears that a temporary table and temporary
>>> index were being created within the same second that the query was run.
>>>
>>> Any advice?
>>
>>
>> WHERE
>>     relkind = 'r'
>> AND
>>     relpersistence != 't'
> So to confirm. Fix the query and don't worry?

Well it is software, so always worry:) To reduce the worry level I would
confirm that there is really no current relation with an OID of
597597503. Still given that the query ran successfully on retry and that
it failed in the presence of a temporary table creation I would say the
evidence is that a temporary table disappeared out from under the query.

>
> Cheers,
> Steve
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com