postgres/perl, autocommit and BEGIN; COMMIT;

[Lloyd Budd]

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 .

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