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@sss.pgh.pa.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@esri.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