Re: Accessing a database via AJAX scripts

From: Vick Khera <vivek(at)khera(dot)org>
To: Glen Eustace <geustace(at)godzone(dot)net(dot)nz>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Accessing a database via AJAX scripts
Date: 2010-08-18 15:29:19
Message-ID: AANLkTimzx=Bue15FoCc_z67FqZ60DPvQHYfXt9NxKNf+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Aug 8, 2010 at 5:08 PM, Glen Eustace <geustace(at)godzone(dot)net(dot)nz> wrote:
> Thanks Tom, that is pretty much the conclusion I came to.  I think I need to
> close the db connection prior to the fork and then re-open in the new child.
>

Yes, you pretty much have to do this. I usually do the close
immediately after fork in the child, but set the DBI attribute
InactiveDestroy on the handle so it doesn't destroy the parent's
handle.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-08-18 15:37:17 Re: Win32 Backend Cash - pre-existing shared memory block is still in use
Previous Message Thom Brown 2010-08-18 15:23:17 Re: Are Indices automatically generated for primary keys?