postgres/perl, autocommit and BEGIN; COMMIT;

[Madison Kelly]

Lloyd Budd wrote:
> 
> On 27-May-04, at 15:18, Madison Kelly wrote:
> 
>>   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";).
> 
> I have not done postgres , but in @ least one other DBMS you would not 
> explicitly do ,
> a BEGIN , only the COMMIT .

   Thanks for the reply!

   Humm, how do I stop the default behavior of committing automatically 
for this one batch then?

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