Ok, you're right, BEGIN EXCLUSIVE does lock the file and keep it locked until COMMIT or ROLLBACK.
However, I need transactions for other purposes, as my process is running it will need to BEGIN and COMMIT/ROLLBACK transactions all the while holding the lock on the file. Will Leshner <[EMAIL PROTECTED]> wrote on 06/17/2005 02:04:01 PM: > > On Jun 17, 2005, at 10:52 AM, [EMAIL PROTECTED] wrote: > > > Yes, a BEGIN EXCLUSIVE does lock it, but then as soon > > as I do some other SQL, it automatically UN LOCKS the > > db unfortunately. I need to keep it locked until > > I unlock it. > > > I'm not sure I believe you :) I would assume the database would be > locked until COMMIT or ROLLBACK.
