Insert fail: could not open relation with OID 3221204992
От | araza@esri.com |
---|---|
Тема | Insert fail: could not open relation with OID 3221204992 |
Дата | |
Msg-id | 7CAD6D9B7D16BC4A88795771E48650820532225C@pianowire.esri.com обсуждение исходный текст |
Ответ на | Re: deleting a foreign key that has no references (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Insert fail: could not open relation with OID 3221204992
|
Список | pgsql-general |
Hi all, 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 ) This is happening only on Linux , on Windows (pg 8.2.1), I can insert all data. I have gone through all the hints on the list for this thread and tried most of them, like - reindex pg_class - set enable_indexscan = off; - increase shared_buffers /temp_buffers - SELECT oid, relname, relkind FROM pg_catalog.pg_class WHERE oid <= 3221204992 ORDER BY oid DESC LIMIT 6; There is no temporary table and no table is being dropped / created. No record is returned for select oid, * from pg_class where oid = 3221204992; Wondering if somebody have some other hints to resolve this problem? Thanks. Ale Raza.
В списке pgsql-general по дате отправления: