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

Tom,

No problem without shape column. I can load all data.

# SELECT oid, relname, relkind FROM pg_catalog.pg_class WHERE oid <=
3221204992 ORDER BY oid DESC LIMIT 6;
oid | relname | relkind
-------+----------------------+---------
78036 | pg_toast_78032_index | i
78034 | pg_toast_78032 | t
78032 | parcel | r
78031 | pg_toast_78027_index | i
78029 | pg_toast_78027 | t
78027 | parcel_t | r
(6 rows)

Table parcel_t: without shape.
Table parcel: with shape.

My concern is:
- Why it's an issue on Linux not on windows? In both cases it's a window
client.
- What shape column making insert fail?

Ale.

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

araza(at)esri(dot)com writes:
> Here is the schema info:
> ...
> shape | st_geometry |

> st_geometry is our own implementation for geometry type.

To be blunt, I'd suggest looking there first. Can you duplicate the
failure when loading into a table with no custom datatype?

regards, tom lane