"Sergey Tomoulevitch" <phoinix.pub...@gmail.com> writes:
> When I send command in async query, eq:
> SELECT dblink_send_query('remoteconn', 'INSERT INTO mytable (f1, f2) VALUES
> (1,2);');
> I can not get result for this, eq:
> SELECT dblink_get_result('remoteconn');
> I got error "ERRCODE_DATATYPE_MISMATCH".
I'm not sure whether there is a code bug here, but the documentation for
dblink_get_result() says that you have to specify a result rowtype for
it. So you need something more like
SELECT * FROM dblink_get_result(''remoteconn') as t1(f1 text);
Does it work if you do that?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
