Re: [GENERAL] dblink - custom datatypes don't work

From: Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk>
To: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>
Subject: Re: [GENERAL] dblink - custom datatypes don't work
Date: 2004-02-11 18:03:48
Message-ID: 402A6E84.9020309@cromwell.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

Mark Gibson wrote:

> Well, I've re-compiled PostgreSQL 7.4.1 with --enable-debug
> (was previously working with a Gentoo ebuild of it).
> And strangely I get a different error now:
>
> ERROR: query-specified return row and actual function return row do
> not match
>
> After placing a few elog statements around pgresultGetTupleDesc, i've
> found the
> error happens after this function.
>
Thanks for the tips of using gdb.

I've found that dblink works without the oid map, ie: dblink(... , ... ,
false)
but returns the error when enabled, ie: dblink(... , ... , true)

The only part of dblink affected by this flag (use_oid_map) is within
'pgresultGetTupleDesc'

and the only variable affected is 'atttypid'
- which is left alone if use_oid_map is false.
When use_oid_map is true, SPI is used to prepare a query,
and execute it for each attribute - atttypid is then assigned the
value retreived from the query.

So when no custom types are used, the same values are passed to
'TupleDescInitEntry' whether use_oid_map is true or false.

I just can't work it out!

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2004-02-11 18:10:47 Re: sybase->postgresql
Previous Message Ashish Mahabal 2004-02-11 18:01:15 Re: sybase->postgresql

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2004-02-11 20:43:41 Re: PITR Dead horse?
Previous Message Jim C. Nasby 2004-02-11 17:46:24 Re: RFC: Security documentation

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-02-11 21:47:09 Thread redesign
Previous Message Bruce Momjian 2004-02-11 17:29:54 Threading bug