Re: DBD::PostgreSQL

On Monday, November 18, 2002, at 09:55  AM, Rudy Lippan wrote:

> I don't know what would be worse: Always having a transaction open 
> when I
> am not in automcommit mode, and knowing about it, or having to worry
> whether I am in transaction because of some stmt that I or some other
> module issued (Including DBD::Pg).

I think that we could probably prevent the driver's statements from 
interfering with that, particularly if they're performed in dbdimp.c 
rather than in Pg.pm.

> I look at it this way... make it simple and bullet-proof and then 
> optimize
> if needed.

Right.

> Is that not what prepare_cached is for? One should only be preping
> the statement once anyway, right?

Right. I wasn't sure if that was already happening or not -- I haven't 
got that far in the code yet. :-)

> And the statement gets parsed twice by DBD::Pg. One time in prepare and
> One time in execute (for the substitution of parameters).

Right, although if we can add support for true prepared statements, we 
could eliminate the second parsing.

> Missed the q3.
>
> PREPARE plan_name [ (datatype [, ...] ) ] AS  query
>
> I guess I read that as (datatype) being optional... I guess it is only
> optional if there are no $1 &c. in the query, then.

Right, unfortunately true -- for now, anyway.

Regards,

David

-- 
David Wheeler                                     AIM: dwTheory
david@wheeler.net                                 ICQ: 15726394
http://david.wheeler.net/                      Yahoo!: dew7e                                               Jabber:
Theory@jabber.org