postgres/perl, autocommit and BEGIN; COMMIT;

[Madison Kelly]

Fraser Campbell wrote:
> 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.

   Ohhh! Maybe that is what they were trying to say in the perl/DBI book 
that I wasn't getting. Thanks! I will try it in an hour or two once I 
finish this other part of the program I am fighting with :).

Madison

--
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