Re: Releasing locks - Mailing list pgsql-novice

From GH
Subject Re: Releasing locks
Date
Msg-id 20001125165649.A39388@over-yonder.net
Whole thread Raw
In response to Re: Releasing locks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Sat, Nov 25, 2000 at 05:53:31PM -0500, some SMTP stream spewed forth:
> GH <grasshacker@over-yonder.net> writes:
> > Is there some way to release the "bad" lock?
>
> Kill the client holding it.
>
> In a persistent-connection environment, you'd have to ensure that any
> connection that client had open was closed, not just recycled to the
> free pool.  Hmm, another thing I bet PHP doesn't do ...
>

AOLServer is looking much better, at least for our database stuff.
Funny, PHP works rather well with MySQL... ;-)
(No harm intended to zealots of either PHP or MySQL. Heck, my job
practically depends on PHP, but I wish it would *work* when I need it
too.)

Yet again, our hero Tom Lane rescues the hapless newbies.

Thanks.
gh


>             regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Releasing locks
Next
From: Ron Chmara
Date:
Subject: Re: Re: re : PHP and persistent connections