Re: opened connection - Mailing list pgsql-general

From Jasen Betts
Subject Re: opened connection
Date
Msg-id k4bkle$p5l$1@reversiblemaps.ath.cx
Whole thread Raw
In response to opened connection  (Levente Kovacs <leventelist@gmail.com>)
List pgsql-general
On 2012-10-01, Levente Kovacs <leventelist@gmail.com> wrote:
> On Sun, 30 Sep 2012 20:24:47 -0700
> Darren Duncan <darren@darrenduncan.net> wrote:
>
>
>> Unless you have very unique needs, keeping an open connection for
>> days is just wrong anyway; if its for the sake of some user GUI or
>> shell, there probably should be safeguards there to encourage users
>> to not keep long-running transactions or connections.
>
> Okay. Thanks for the answers. I implemented an alarm for the timeout, and I
> close the connection when it is not needed in certain amount of time.
>
> However, I have an other question.
> Calling PQfinish() on an already closed connection makes my program
> segfault. Is this normal?

Absolutely. Calling PQfinish on any other pointer to unallocated
heap is likely to cause a segfault too. same as calling fclose()
on a closed, (or unopened), FILE*.




--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: strange permission error
Next
From: Phoenix Kiula
Date:
Subject: Again, problem with pgbouncer