Re: DBD::PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Wheeler <david(at)wheeler(dot)net>
Cc: Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>, dbi-dev(at)perl(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBD::PostgreSQL
Date: 2002-11-18 17:12:43
Message-ID: 250.1037639563@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

David Wheeler <david(at)wheeler(dot)net> writes:
> I'm quite sure that in PostgreSQL, transactions have to be started
> explicitly.

As of 7.3 that's not necessarily so anymore; you can "SET autocommit TO
off" and get the behavior where any statement starts a transaction block
(and so an explicit COMMIT is required to commit its effects). Not
sure if this helps you or not.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message scott.marlowe 2002-11-18 17:13:55 Re: DECLARE CURSOR
Previous Message David Wheeler 2002-11-18 17:06:30 Re: DBD::PostgreSQL

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Wheeler 2002-11-18 17:15:16 Re: PREPARE and parameter types (Re: [INTERFACES] DBD::PostgreSQL)
Previous Message David Wheeler 2002-11-18 17:06:30 Re: DBD::PostgreSQL