Re: ERROR: relation with OID 1322527 does not exist

[Dragan Zubac <zubac@xxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxxxxx>:
  

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/