From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dblink_get_result issue |
Date: | 2010-11-10 17:28:20 |
Message-ID: | C4DAC901169B624F933534A26ED7DF31034BB8C8@JENMAIL01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> (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(at)postgresql(dot)org'
Subject: dblink_get_result issue
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-11-10 17:28:44 | Re: PostgreSQL 8.2.3 |
Previous Message | Marc Mamin | 2010-11-10 17:24:54 | dblink_get_result issue |