Re: Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

2021-09-08 Thread Jannis Harder
On 08.09.21 18:37, Tom Lane wrote: PG Doc comments form writes: The docs mention "For example, a common use of advisory locks is to emulate pessimistic locking strategies typical of so-called “flat file” data management systems" which is exactly what I wanted to use to port some code from using

Re: Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

2021-09-08 Thread Tom Lane
PG Doc comments form writes: > The docs mention "For example, a common use of advisory locks is to emulate > pessimistic locking strategies typical of so-called “flat file” data > management systems" which is exactly what I wanted to use to port some code > from using SQLite to using PostgreSQL. (

Re: Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

2021-09-08 Thread Laurenz Albe
On Wed, 2021-09-08 at 08:23 +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/explicit-locking.html > Description: > > The docs mention "For example, a common use of advisory locks is to emulate >

Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

2021-09-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/explicit-locking.html Description: The docs mention "For example, a common use of advisory locks is to emulate pessimistic locking strategies typical of so-called “flat file” data manageme