"Pat Wibbeler" <[EMAIL PROTECTED]> wrote: > You can use BEGIN IMMEDIATE or BEGIN EXCLUSIVE depending on the type of > lock you'd like. >
If you are just trying to make sure the database does not change while you back it up, then Jay's suggestion of BEGIN IMMEDIATE is the better approach (better than my suggestion of BEGIN EXCLUSIVE) since BEGIN IMMEDIATE only gets a read lock and thus allows other processes to continue reading the database while the backup is taking place. -- D. Richard Hipp <[EMAIL PROTECTED]>