Delain Huggins wrote:
>
> We are getting ready to set up a Postgres database w/Access frontend with
> 15-25 users. What are the record locking concerns that we need to be aware
What's PG version? 6.5?
> of? Where is record locking set and what levels are there if any? Can
In 6.5 writers lock changed records and block the-same-row writers only.
> queries/reports be run off a record that is being edited at the same time?
Yes (in 6.5). Queries will return records as they were when
query/transaction began (regardless of _current_ record states).
> We haven't been able to find much info on Postgres and record locking.
PostgreSQL User's Guide, Chapter 10. Multi-Version Concurrency Control
Vadim
