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.
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 |
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 |
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 |