Paul Bohme <paul.bohme-eO9kqG/[EMAIL PROTECTED]> wrote:
I have a small patch that adds "BEGIN SHARED" syntax in addition to IMMEDIATE and EXCLUSIVE. I have an application that requires a consistent view of the data across a number of individual statements. What is ideal is a way to simply lock the database with a SHARED lock for the duration, but the only way to do this is run a SELECT.
I'm not sure why you want to lock immediately. The very first of those "individual statements" will set a SHARED lock. All subsequent statements will see the same data as the first one. You get consistent view of the data anyway.
Igor Tandetnik
