Is there a way to check if a db connection handle is still valid?

From: Antai Ning <aning(at)jetnet(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there a way to check if a db connection handle is still valid?
Date: 2002-05-30 20:28:04
Message-ID: F72CDFC92CAA204A9BE73476EED3821D015E62@JETMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Is there a way to check if a db connection handle is still valid?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Hi there,</FONT>
</P>

<P><FONT SIZE=2>Is there a way to check if a db connection handle is still availble? My db program need to run forever and I found that if one insertion fails, the handle seems crashed. Then when the next insertion using the same handle will kill the whole program.</FONT></P>

<P><FONT SIZE=2>Thanks in advance!</FONT>
</P>

<P><FONT SIZE=2>Andy </FONT>
</P>

</BODY>
</HTML>

Attachment Content-Type Size
unknown_filename text/html 724 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Quinot 2002-05-30 20:40:36 Re: Is there a way to check if a db connection handle is still valid?
Previous Message Tom Lane 2002-05-30 20:22:52 Re: horrendous query challenge :-)