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