Insert fail: could not open relation with OID 3221204992 - Mailing list pgsql-general

From araza@esri.com
Subject Insert fail: could not open relation with OID 3221204992
Date
Msg-id 7CAD6D9B7D16BC4A88795771E48650820532225C@pianowire.esri.com
Whole thread Raw
In response to Re: deleting a foreign key that has no references  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Insert fail: could not open relation with OID 3221204992  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi all,

I am inserting 783159 records but the insert is failing after 634314
records. I am getting "ERROR:  could not open relation with OID
3221204992" message. I am using

1- PostgreSQL: 8.2.3
2- OS: Red Hat Enterprise Linux AS release 3.
3- Logfile output:
ERROR:  XX000: could not open relation with OID 3221204992
LOCATION:  relation_open, heapam.c:700
STATEMENT:  INSERT INTO parcel (OBJECTID, shape) VALUES ( $1,  $2 )

This is happening only on Linux , on Windows (pg 8.2.1), I can insert
all data.

I have gone through all the hints on the list for this thread and tried
most of them, like
- reindex pg_class
- set enable_indexscan = off;
- increase shared_buffers /temp_buffers
- SELECT oid, relname, relkind FROM pg_catalog.pg_class WHERE oid <=
3221204992 ORDER BY oid DESC LIMIT 6;

There is no temporary table and no table is being dropped / created.

No record is returned for
    select oid, * from pg_class where oid = 3221204992;

Wondering if somebody have some other hints to resolve this problem?

Thanks.
Ale Raza.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: can't trace error!!!
Next
From: "Martin Gainty"
Date:
Subject: Re: best way to kill long running query?