postgres/perl, autocommit and BEGIN; COMMIT;

[Fraser Campbell]

On Thursday 27 May 2004 15:18, Madison Kelly wrote:
> Hi all,
>
>    I was playing more with trying to get the database performance up
> when I realised that I needed to "COMMIT" to aply the updates. Realising
> this I decided to turn postgres' 'autocommit' back off and instead use
> "BEGIN/COMMIT" only on the large SELECT/INPUT/UPDATE section. The
> problem though is that no matter what I seem to try perl throws an empty
> error (generic software error) whenever this call is made
> ($db->do("BEGIN") || die "$DBI::errstr";).

Perhaps these do the trick?

       $db->begin_work;
       $db->commit;
       $db->rollback;

Not sure since I'm no pgsql expert.

-- 
Fraser Campbell <fraser-Txk5XLRqZ6CsTnJN9+BGXg at public.gmane.org>                 http://www.wehave.net/
Georgetown, Ontario, Canada                               Debian GNU/Linux
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml