Message-ID: <13669451.4531041312288568915.JavaMail.defaultUser@defaultHost>
Date: Tue, 2 Aug 2011 14:36:08 +0200 (CEST)
From: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
Reply-To: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
To: pgsql-admin@postgresql.org
Subject: dblink question about duplicate connection
MIME-Version: 1.0
Content-Type: text/plain;charset="UTF-8"
Content-Transfer-Encoding: 7bit

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