perform dblink_exec('hostaddr=172.16.3.33 port=1921 dbname=digoal user=digoal password=digoal','rollback prepared ''p1'''); end if; return; end; $BODY$ language plpgsql; (5将违反约束,因此应该在执行v_trace = 'LOCAL start';之前抛出异常,来看看结果) digoal=> select * from fun_test(); ...
PostgreSQL 9.3.1 中文手册 上一页 上一级 下一页dblink_exec 名称dblink_exec -- 在远程数据库中执行命令 大纲 dblink_exec(text connname, text sql [, bool fail_on_error]) returns text dblink_exec(text connstr, text sql [, bool fail_on_error]) returns text dblink_exec(text sql [, bool...
For example, the following statement runs a row count in PostgreSQL and retrieves the result (6,001,215) in Vertica: =>SELECTDBLINK(USING PARAMETERS cid='pgdb', query='SELECT COUNT(*) FROM tpch.lineitem') OVER(); count---6,001,215--- 1 row selected in 0.228s (prep 0.17s, exec ...
To: Oleg Lebedev Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] dblink: rollback transaction Oleg Lebedev said: > Is there a way to rollback a dblink transaction? > Say, I delete some data from the remote database, but I don't want > this to be visible untill the data i...
yum install postgresql-contrib.i386su - postgres$ cat /usr/share/pgsql/contrib/dblink.sql | psql$psql tst_db$tst_db# select dblink_connect('host=localhost user= password=');$tst_db# select dblink('select id from tst') as mytable (t int);$tst_db# select dblink_exec('insert into ...