From: Joe Conway <mail@joeconway.com>
To: Frankie <frankie@ucr.com.hk>
Cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql + dblink() question
Date: Fri, 07 Feb 2003 22:03:23 -0800
Message-ID: <3E449DAB.9050106@joeconway.com> (raw)
In-Reply-To: <b225au$o4g$1@news.hub.org>
References: <b225au$o4g$1@news.hub.org>
Frankie wrote:
> The case is when I call a function (from Server 1 at psql prompt) that will
> call dblink to do some operation
> on another server(it will take certain time), i.e. Server 2, and meanwhile I
> just unplug the network cable to Server 2.
> The consequence is that the function will never return except I plug the
> cable into it again, moreover I cannot even cancel
> the query and stop the postgresql server (have to 'kill -9'.)
dblink just uses libpq to handle the communication, so you can use the
connect_timeout connection parameter. It defaults to infinite if not
explicitly set. Something like this should set a 5 second timeout:
select * into tmp from dblink(''host=linux dbname=twins connect_timeout=5'',
''select mysleep();'') as (retval text);
See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/libpq-connect.html
HTH,
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, frankie@ucr.com.hk
Subject: Re: plpgsql + dblink() question
In-Reply-To: <3E449DAB.9050106@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox