Re: [SQL] 7.1.1 Lock Problems on Views

2001-05-31 Thread Brian Powell
On Thursday, May 31, 2001, at 10:42 AM, Tom Lane wrote: > Why don't you redesign the app to not use table-level locks? > An MVCC-aware app should have little or no need for table-level > locking. > Thanks, I'll read up on MVCC in the docs. While digging around, I came across the MVCC and it w

Re: [SQL] 7.1.1 Lock Problems on Views

2001-05-31 Thread Tom Lane
Brian Powell <[EMAIL PROTECTED]> writes: > In our client app, we lock our table before doing something to it. Why don't you redesign the app to not use table-level locks? An MVCC-aware app should have little or no need for table-level locking. Locking views strikes me as a pretty fragile, if n

[SQL] 7.1.1 Lock Problems on Views

2001-05-31 Thread Brian Powell
Greetings, I am investigating whether our application will run on 7.1.1 (from 7.0.3), and our client software only accesses the database through views for security and convenience. In our client app, we lock our table before doing something to it. Fortunately, in 7.0.3, a view looked like a