Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: cache lookup failed for type 0 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cache lookup failed for type 0
Date
Msg-id 29191.1105129867@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: cache lookup failed for type 0  (Tzahi Fadida <tzahi_ml@myrealbox.com>)
Responses Re: ERROR: cache lookup failed for type 0  (Tzahi Fadida <tzahi_ml@myrealbox.com>)
List pgsql-general
Tree view 
Tzahi Fadida <tzahi_ml@myrealbox.com> writes:
> It still doesn't work. btw, I am using 8rc2.

Um.  The "clean" way to do this is to use BlessTupleDesc and then
heap_formtuple.  That requires you to break down the original tuple
into fields (see heap_deformtuple).  Alternatively you could poke
the datatype ID fields directly into the copied tuple.

            regards, tom lane

pgsql-general by date:

Previous
From: "Craig Bryden"
Date:
Subject: MS-SQL to PostgreSQL
Next
From: Michael Fuhr
Date:
Subject: Re: MS-SQL to PostgreSQL