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@xxxxxxxxxxxxx] 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@xxxxxxxx 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
