> When comitting a transaction I get an error "database or disk is full". But > there is 6 Gb of free space on my hard drive. Database is about 4 Gb. > There is no error when doing the same inserts but without transaction. > > Why does it happen?
This is just a guess: Is your transaction so large it takes more than 4 gig to save the info it needs to roll it back? In general you probably need at least as much free disk space as there is for the database if you have to do massive transactions. It might have to duplicate the entire database..
