R: Re: dblink question about duplicate connection

Thanks, I solved it with your help.

Francesco Boccacci

>----Messaggio originale----
>Da: mail(at)joeconway(dot)com
>Data: 02/08/2011 22.46
>A: "francescoboccacci(at)libero(dot)it"<francescoboccacci(at)libero(dot)it>
>Cc: <pgsql-admin(at)postgresql(dot)org>
>Ogg: Re: [ADMIN] dblink question about duplicate connection
>
>On 08/02/2011 05:36 AM, francescoboccacci(at)libero(dot)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(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>