Re: [GENERAL] dblink_get_result issue

2010-11-13 Thread Joe Conway
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

Re: [GENERAL] dblink_get_result issue

2010-11-11 Thread Marc Mamin
: 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

Re: [GENERAL] dblink_get_result issue

2010-11-10 Thread Tom Lane
"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

Re: [GENERAL] dblink_get_result issue

2010-11-10 Thread Marc Mamin
> (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