Re: [GENERAL] dblink not returning result

2011-11-03 Thread robins . tharakan
This message has been digitally signed by the sender. Re___GENERAL__dblink_not_returning_result.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] dblink not returning result

2011-11-03 Thread Robins Tharakan
Hi, From reading your email and from the URL below, it seems that the error is because it's returning the status of the first call (where you are beginning the transaction and making the first query). http://www.postgresql.org/docs/9.1/static/contrib-dblink-get-result. Have you tried doing a

[GENERAL] dblink not returning result

2011-11-03 Thread AI Rumman
I am using Postgresql 9.1. I found that dblink is not returning result for BEGIN transaction. select new_conn('conn1'); select new_conn('conn2'); select dblink_send_query('conn1','begin; update t2 set i=10 where nam=''a1'';'); select