From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, "'pgsql-general(at)postgresql(dot)org' (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: could not open relation with OID |
Date: | 2015-04-22 23:27:52 |
Message-ID: | 55382E78.6090203@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-04-22 23:37:10 | Re: Connecting to 2 different DB on same machine |
Previous Message | John R Pierce | 2015-04-22 22:06:23 | Re: LDAP Authentication |