From: | aasat <satriani(at)veranet(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Bug: dblink_send_query not work on 9.2? |
Date: | 2013-01-09 13:55:14 |
Message-ID: | 1357739714553-5739365.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have problem with dblink_send_query function on Postgres 9.2.2
This work
do $$
begin
perform dblink.dblink_connect('internal');
perform dblink.dblink_exec('internal', 'set application_name=''dblink'';',
true);
perform dblink.dblink_disconnect();
end;
$$
But this not
do $$
begin
perform dblink.dblink_connect('internal');
perform dblink.dblink_send_query('internal', 'select dummy();');
perform dblink.dblink_disconnect();
end;
$$
I got error
ERROR: connection "internal" not available
SQL state: 08003
Context: SQL statement "SELECT dblink.dblink_send_query('internal', 'select
dummy();')"
PL/pgSQL function inline_code_block line 5 at PERFORM
It's works without problems on version 9.0
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Bug-dblink-send-query-not-work-on-9-2-tp5739365.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-01-09 14:35:39 | Re: Getting PLPython to work with PostgreSQL 9.2 |
Previous Message | James Cowell | 2013-01-09 10:43:27 | Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master |