Re: DBD::PostgreSQL

From: David Wheeler <david(at)wheeler(dot)net>
To: Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
Cc: Rudy Lippan <rlippan(at)remotelinux(dot)com>, dbi-dev(at)perl(dot)org, pgsql-interfaces(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: DBD::PostgreSQL
Date: 2002-11-18 18:03:54
Message-ID: 1A15B4B0-FB20-11D6-93B3-0003931A964A@wheeler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

On Monday, November 18, 2002, at 09:44 AM, Tim Bunce wrote:

> Just to be sure this is clear, begin_work is *just* an alternative
> way to set AutoCommit off till the next commit or rollback. The
> application is free to just set AutoCommit explicitly as needed.
>
> The *only* time a driver needs to consider the BegunWork attribute
> is immediately after a commit or rollback.

Okay, thanks for the clarification, Tim.

> Should need to "parse" in the formal sense, no full grammar is
> needed, it's just a very quick skim through the string. If done in
> C it should be too cheap to worry about. Especially as it's only
> done at prepare() time, not execute().

Okay. I'm used to thinking about things in Perl time, so I'm not quite
sure about the expense of the c code stuff. Thanks for the tip.

> Would binding a string type to an integer (etc) placeholder work?
> If so, just ignore the types and bind everything as strings.
> That's exactly what DBD::Oracle does.

Well, it wouldn't work for bytea columns, but that's true with
non-prepared statements already, anyway. Interesting idea, and I think
you may well be right.

Tom, can you confirm?

Thanks,

David

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jason Hihn 2002-11-18 18:04:00 Re: Press Release -- Just Waiting for Tom
Previous Message Haris Peco 2002-11-18 17:57:46 Re: [GENERAL] DECLARE CURSOR

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Wheeler 2002-11-18 18:07:06 Re: DBD::PostgreSQL
Previous Message Rudy Lippan 2002-11-18 17:55:08 Re: DBD::PostgreSQL