Re: ERROR: relation with OID 1322527 does not exist

Hello

Have the same problem but in ordinary usage,no replication or
whatsoever. Problem is when client connects to the DB,stored procedure
in its initialization check mapping between some_table_name and
corresponding OID. Once something is changed in DB,for example OID's
deleted and recreated or something similar,You'll have errors in Your
log file. After changes are done,and You restart Your application which
reconnect to the DB,things are normal back again.

Sincerely

H.Harada wrote:
> 2008/2/20, Geoffrey <lists(at)serioustechnology(dot)com>:
>
>> We've just started seeing these errors. Research I've done seems to
>> indicate that it's related to temp tables. Question is, we didn't start
>> seeing these errors until we started using slony to replicate our data.
>>
>> The errors only showed up shortly after the initial replication of the
>> data was complete. That is, once the replication server 'caught up'
>> with the production server.
>>
>>
> I've ever seen the same error. At that time I didn't use slony but
> replicated some postgresql servers by an application layer. It seemed
> that not only temp table but regular relations are dropped and created
> quickly when the error occurred.
> There could be a chance to drop information about relations or
> themselves between SELECT catching relation OID and begining scan the
> relation actually.
>
> I have no solution for this until now. But just for your information.
>
>
> Hitoshi Harada
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
>