On 11/10/2010 03:54 PM, Tom Lane wrote:
> "Marc Mamin" 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
: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Donnerstag, 11. November 2010 00:54
To: Marc Mamin
Cc: pgsql-general@postgresql.org; Joe Conway
Subject: Re: [GENERAL] dblink_get_result issue
"Marc Mamin" writes:
> I'm experimenting with dblink, and have an issue with async. qu
"Marc Mamin" writes:
> I'm experimenting with dblink, and have an issue with async. queries
> that do not return result sets.
> (Postgres 8.3.9)
> --youll need your own connect string to repeat:
> select dblink_connect_u('myconn1', 'hostaddr=127.0.0.1 port=5432
> dbname=postgres user=postgres
> (Postgres 8.3.9)
oops, this is actually 8.4.4 on Windows.
-Original Message-
From: Marc Mamin
Sent: Mittwoch, 10. November 2010 18:25
To: 'pgsql-general@postgresql.org'
Subject: dblink_get_result issue
Hello,
I'm experimenting with dblink, and have an issue with async. queries
that d