Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-26 Thread Tom Lane
"Ale Raza" <[EMAIL PROTECTED]> writes: > Same results with -O0 option. Hmmm ... I guess I should have stopped to read the code a little closer: >> Breakpoint 1, ST_Geometry_Recv (fcinfo=0xbfffcb90) at binary.c:138 >> 138 StringInfo src_buf = (StringInfo) > PG_DETOAST_DATUM(PG_GETARG_D

Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-23 Thread Tom Lane
"Ale Raza" <[EMAIL PROTECTED]> writes: > Breakpoint 1, ST_Geometry_Recv (fcinfo=0xbfffcb90) at binary.c:138 > 138 StringInfo src_buf = (StringInfo) > PG_DETOAST_DATUM(PG_GETARG_DATUM(0)); > (gdb) p *src_buf > $4 = {data = 0xff0c8d8b , len = > -1031143425, maxlen = -13595335, cursor =

Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-23 Thread Tom Lane
"Ale Raza" <[EMAIL PROTECTED]> writes: > Breakpoint 3, #_Recv (fcinfo=0xbfffa3a0) at binary.c:138 > 138 StringInfo src_buf = (StringInfo) > PG_DETOAST_DATUM(PG_GETARG_DATUM(0)); > (gdb) p *src_buf > Cannot access memory at address 0x0 At the point where you've stopped, src_buf hasn

Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-22 Thread Tom Lane
"Ale Raza" <[EMAIL PROTECTED]> writes: > No problem without shape column. I can load all data. What I thought :-( > My concern is: > - Why it's an issue on Linux not on windows? In both cases it's a window > client. Platform-dependent bug in your code, likely. Without seeing the code it's imp

Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-22 Thread Tom Lane
[EMAIL PROTECTED] 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?

Re: [GENERAL] Insert fail: could not open relation with OID 3221204992

2007-03-21 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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: