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
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 |