ECPG connection timeouts

"Edmund Bacon" <[email protected]>
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <ABAE5512DA3D4E4597C82947769214380138B9CB@devmail.devstudios.local>
Is it possible to control how long ECPG takes when trying to connect to
a database on a remote system (e.g. connect to tcp:postgres//remote/db)

In my environment it is quite possible that the link to the remote
system may be down, so I'd prefer not to have to force the end-user to
wait 3+ minutes while ECPG CONNECT times out.

I've tried using sig_action()/alarm() and also tried using
setjmp/longjmp with alarm, but to no avail. 

Is there anything I can do within ECPG other than try a plain old
connect() to the remote system on port 5432 and not proceed with a ECPG
CONNECT if that fails?

Thanks,

Edmund Bacon

-- 
Sent via pgsql-interfaces mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.