dblink_get_result issue
От | Marc Mamin |
---|---|
Тема | dblink_get_result issue |
Дата | |
Msg-id | C4DAC901169B624F933534A26ED7DF31034BB8C7@JENMAIL01.ad.intershop.net обсуждение исходный текст |
Ответы |
Re: dblink_get_result issue
Re: dblink_get_result issue |
Список | 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
В списке pgsql-general по дате отправления: