Re: Insert fail: could not open relation with OID 3221204992 - Mailing list pgsql-general

" ...StringInfos aren't a toastable datatype....."

Ok, thanks. This was the issue. Now, I can load all data.

Ale.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, March 26, 2007 6:26 PM
To: Ale Raza
Cc: postgresql-general
Subject: Re: [GENERAL] Insert fail: could not open relation with OID
3221204992

"Ale Raza" <araza@esri.com> 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_DATUM(0));

Where did you get that from?  Receive functions are supposed to do this:

    StringInfo    buf = (StringInfo) PG_GETARG_POINTER(0);

StringInfos aren't a toastable datatype.  The loss of control probably
represents the toast code throwing an error ...

            regards, tom lane