Re: Insert fail: could not open relation with OID 3221204992

Tom,

It's a C API client and inserts are not wrapped into a BEGIN/END.

Here is the schema info:

sde93=# \d parcel
Table "sde.parcel"
Column | Type | Modifiers
----------+-------------+-----------
objectid | integer | not null
shape | st_geometry |

st_geometry is our own implementation for geometry type. In a loading
mode it has no index. Initially, when table is created, a GiST index is
created for shape and a btree for objectid but both are dropped for
loading.

Client is reading data from ESRI personal GeoDatabase and inserting into
parcel table.

The OID is same every time.

Thanks.
Ale.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, March 21, 2007 4:15 PM
To: Ale Raza
Cc: postgresql-general
Subject: Re: [GENERAL] Insert fail: could not open relation with OID
3221204992

araza(at)esri(dot)com writes:
> 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 )

Please provide more detail, like what the table schema is, what indexes
and foreign keys it has, and exactly what the insert process is
(eg do you have all these inserts wrapped in a BEGIN?). Also what is
the client-side software?

Is the OID mentioned in the complaint the same every time you try it?

regards, tom lane