From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com> |
Cc: | Andrej <andrej(dot)groups(at)gmail(dot)com>, JP Fletcher <jpfletch(at)ca(dot)afilias(dot)info>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: prepared statements and DBD::Pg |
Date: | 2009-05-08 01:08:12 |
Message-ID: | 20090508010812.GB18067@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, May 08, 2009 at 01:02:04AM +0100, Tim Bunce wrote:
> On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote:
> > On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote:
> > > On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote:
> > > >
> > > > WARNING: DBD::Pg now (as of version 1.40) uses true prepared
> > > > statements by sending them to the backend to be prepared by
> > > > the Postgres server. Statements that were legal before may no
> > > > longer work.
> > >
> > > Sure seems like a bug, or at best a misfeature, that DBD::Pg
> > > doesn't simply fallback to client-side prepare when a
> > > server-side prepare can't be performed. I believe DBD::mysql
> > > does that.
> >
> > It's a safety feature. :)
>
> Er. I see the smiley but I'm not sure if that's a joke. Can you
> expand?
It's not a joke. Client-side prepare is essentially creating a
duplicate code path and hoping that it does exactly the same thing
that the server-side one does, and this in a context of controlling
access.
If PostgreSQL's parser, etc., were in the form of exportable
libraries, that would be very nice, but until then, making server-side
prepare the only kind is just jungle caution.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Smith | 2009-05-08 03:05:45 | getting a list of users |
Previous Message | Tim Bunce | 2009-05-08 00:02:04 | Re: prepared statements and DBD::Pg |