From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: dblink_get_result issue |
Date: | 2010-11-13 17:34:59 |
Message-ID: | 4CDECC43.90701@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/10/2010 03:54 PM, Tom Lane wrote:
> "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> writes:
>
>> SELECT * FROM dblink_get_result('myconn1', true ) as x (t text);
>
>> =>
>> ********** Error **********
>> remote query result rowtype does not match the specified FROM clause
>> rowtype
> Hmm. I can reproduce this in 8.4 too, but it seems OK in 9.0. The only
> one of the 9.0 commits that seems likely to be relevant is
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56cbb611ec749ba867a4cfc09c8b7df0f4446620
> which looks a bit overcomplex for a back-patch. Joe, any thoughts?
Sorry for the slow response.
I think this issue was fixed by that patch only as a side effect of
significant restructuring. The attached one liner against 8.4 seems to
fix it. Objections?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
Attachment | Content-Type | Size |
---|---|---|
dblink.2010.11.13.1.diff | text/x-patch | 769 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-11-13 18:21:51 | Re: The first dedicated PostgreSQL forum |
Previous Message | Dmitriy Igrishin | 2010-11-13 17:07:50 | Re: The first dedicated PostgreSQL forum |