Re: [GENERAL] Back end timeout?

From: Herouth Maoz <herouth(at)oumail2(dot)openu(dot)ac(dot)il>
To: Lincoln Spiteri <lincoln(dot)spiteri(at)st(dot)com>, "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Back end timeout?
Date: 1998-12-21 10:12:54
Message-ID: l03110708b2a3ccf3e674@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 11:38 +0200 on 21/12/98, Lincoln Spiteri wrote:

> Do you think that the large interval between the first insert and the
> second insert is causing the transaction to timeout with the loss of the
> connection. If yes what can I do to avoid the time out.

Couldn't you locate the data first, and then open the connection, and
perform your transaction with the collected data?

Alternatively, I'd send some dummy queries to the database from time to
time. (i.e. SELECT '';).

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sferacarta Software 1998-12-21 13:29:11 Re[2]: [GENERAL] decimal_part() function
Previous Message Memphisto 1998-12-21 09:41:42 vacuum problem