dblink_get_result issue

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: dblink_get_result issue
Date: 2010-11-10 17:24:54
Message-ID: C4DAC901169B624F933534A26ED7DF31034BB8C7@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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 password=x');

select dblink_send_query('myconn1', 'create temp table bah(s int8);');
select pg_sleep(.3);

SELECT * FROM dblink_get_result('myconn1', true ) as x (t text);

=>
********** Error **********
remote query result rowtype does not match the specified FROM clause
rowtype
SQL state: 42804

A subsequent call returns an empty result set, as described here:

http://www.postgresql.org/docs/8.3/interactive/contrib-dblink-get-result
.html

Thanks for any help.

Marc Mamin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2010-11-10 17:28:20 Re: dblink_get_result issue
Previous Message Bill Moran 2010-11-10 17:12:09 Vacuuming and reindexing tables that I don't own