From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Jan Wieck <JanWieck(at)Yahoo(dot)com>, Marcus Börger <marcus(dot)boerger(at)post(dot)rwth-aachen(dot)de>, ivan <iv(at)psycho(dot)pl>, Joe Conway <mail(at)joeconway(dot)com>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: php with postgres |
Date: | 2003-07-22 16:18:59 |
Message-ID: | Pine.LNX.4.33.0307221018300.19139-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 21 Jul 2003, Bruce Momjian wrote:
> Jan Wieck wrote:
> > Bruce Momjian wrote:
> > > Marcus B?rger wrote:
> > >> BM> Marcus, would you check if PHP is using RESET ALL when passing
> > >> BM> persistent connection to new clients? We added that capability a few
> > >> BM> releases ago, specifically for PHP persistent connections, but I don't
> > >> BM> think that ever got into the PHP code.
> > >>
> > >> Unfortunately we don't do so yet. Do i need to check for errors or can i do it
> > >> unconditionally on conenction start? And i'd need to know how to check if it
> > >> is available (like starting with which version).
> > >
> > > It first appeared in PostgreSQL version 7.2. It doesn't generate any
> > > failures. It just resets all SET settting to their defaults, in case
> > > the previous client modified them.
> > >
> >
> > It does generate the usual error if the current transaction block is in
> > ABORT state. So the correct querystring to send would be something like
> >
> > "ROLLBACK; RESET ALL"
>
> Oh, I remember that now as part of the persistent connection code. As I
> remember, we told them to do BEGIN;COMMIT; to clear any open transaction
> state passed to the new client. Is that in there? If not, it has to be
> added too. ROLLBACK will generate an error if you are not in a
> transaction, so it would fill the logs with errors.
Won't that break when we have nested transactions implemented? i.e.
begin;commit; would just open a sub transaction and have no effect on the
outer transaction...
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-07-22 16:28:36 | Re: dblink_ora - a first shot on Oracle ... |
Previous Message | Lee Kindness | 2003-07-22 16:10:04 | Re: [PATCHES] PATCH: Memory leaks on start-up |