Re: [Re] Re: PREPARE and transactions - Mailing list pgsql-hackers

From Jeroen T. Vermeulen
Subject Re: [Re] Re: PREPARE and transactions
Date
Msg-id 20040704214155.GZ50626@xs4all.nl
Whole thread Raw
In response to Re: [Re] Re: PREPARE and transactions  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
On Sun, Jul 04, 2004 at 06:39:46PM -0000, Greg Sabino Mullane wrote: 
> > There's no actual extra parsing involved, as far as I can see, just
> > pattern matching and the extraction of the variables.
>  
> That sounds like "parsing" to me. :) 
Depends on your definition, I guess.  I would say very limited lexical
analysis, yes, but nothing involving actual structure beyond individual
lexical tokens.


> It's already been done in DBD::Pg. Naming starts at dbdpg_1 and goes to
> dbdpg_2, dbdpg_3, etc. The only requirement we ask of the application
> using it is that you don't prepare statements yourself named "dbdpg_x".
> In most cases, the application does not worry about the naming anyway,
> but simply issues an anonymous prepare request through DBIs paradigm of
> one statement handle bound to a single SQL statement. DBD::Pg also does
> the deallocating itself, and keeps track of the transaction status as well.
> Deallocation is merely a courtesy anyway, as we don't reuse the names.
>  
> If there are flaws in the above design, I'd like to know about them,
> as all of this prepare/execute stuff is rather new and undertested.

Can't think of any, as long as you don't try to manage the connection.


Jeroen



pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: [Re] Re: PREPARE and transactions
Next
From: Bruce Momjian
Date:
Subject: Re: Compile failure in plperl