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

[araza(at)esri(dot)com]

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