Re: opened connection

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: opened connection
Дата
Msg-id k4bkle$p5l$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на opened connection  (Levente Kovacs <leventelist@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: strange permission error
Следующее
От: Phoenix Kiula
Дата:
Сообщение: Again, problem with pgbouncer