| From: | "francescoboccacci(at)libero(dot)it" <francescoboccacci(at)libero(dot)it> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | dblink question about duplicate connection |
| Date: | 2011-08-02 12:36:08 |
| Message-ID: | 13669451.4531041312288568915.JavaMail.defaultUser@defaultHost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Dear all,
i have a question about dblink connection.I use it in a trigger function :
CREATE OR REPLACE FUNCTION setuser()
RETURNS trigger AS
$BODY$
DECLARE
BEGIN
IF (TG_OP = 'INSERT') THEN
PERFORM dblink_connect('conn_test', 'dbname=database_test');
PERFORM dblink_exec('conn_test','insert into users
......
Somentimes happend that an error accours in insert data and when i try to run
new insert posgresql return and error like duplicate connection.
I would like to change my functions in this way:
CREATE OR REPLACE FUNCTION setuser()
RETURNS trigger AS
$BODY$
DECLARE
BEGIN
IF (TG_OP = 'INSERT') THEN
If 'conn_test' exist PERFORM dblink_disconnect('conn_test');
else
PERFORM dblink_connect('conn_test', 'dbname=database_test');
PERFORM dblink_exec('conn_test','insert into users
How can write my new function?
Thanks
Francesco Boccacci
| From | Date | Subject | |
|---|---|---|---|
| Next Message | RBharathi | 2011-08-02 12:46:46 | Characterset Equivalent for AL32UTF8 in Postgres |
| Previous Message | Lukasz Brodziak | 2011-08-02 12:32:07 | Re: Gbtreekey16 type |