Thanks, I solved it with your help.
Francesco Boccacci
>----Messaggio originale----
>Da: mail@xxxxxxxxxxxxx
>Data: 02/08/2011 22.46
>A: "francescoboccacci@xxxxxxxxx"<francescoboccacci@xxxxxxxxx>
>Cc: <pgsql-admin@xxxxxxxxxxxxxx>
>Ogg: Re: dblink question about duplicate connection
>
>On 08/02/2011 05:36 AM, francescoboccacci@xxxxxxxxx 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@xxxxxxxxxxxxxx)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
