Thread: R: Re: dblink question about duplicate connection

R: Re: dblink question about duplicate connection

From
"francescoboccacci@libero.it"
Date:
Thanks, I solved it with your help.

Francesco Boccacci

>----Messaggio originale----
>Da: mail@joeconway.com
>Data: 02/08/2011 22.46
>A: "francescoboccacci@libero.it"<francescoboccacci@libero.it>
>Cc: <pgsql-admin@postgresql.org>
>Ogg: Re: [ADMIN] dblink question about duplicate connection
>
>On 08/02/2011 05:36 AM, francescoboccacci@libero.it wrote:
>> 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:
>
>>      If 'conn_test' exist  PERFORM dblink_disconnect('conn_test');
>>      else
>>
>>      PERFORM dblink_connect('conn_test', 'dbname=database_test');
>
>> How can write my new function?
>
>See dblink_get_connections():
>http://www.postgresql.org/docs/9.0/interactive/contrib-dblink-get-connections.
html
>
>HTH,
>
>Joe
>
>--
>Joe Conway
>credativ LLC: http://www.credativ.us
>Linux, PostgreSQL, and general Open Source
>Training, Service, Consulting, & 24x7 Support
>
>--
>Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>