Thread: Locking Mechanism

Locking Mechanism

From
"lucas sultanum"
Date:
I have been reading a lot about PostGreSQL but until now I haven't found an=
ything stating if the PostGreSQL database has any locking mechanism. If so,=
 could you send me anithing about this esue??

Thank you very much!!!=

Re: Locking Mechanism

From
Neil Conway
Date:
The pgsql-bugs mailing list is intended for bug reports about
PostgreSQL, not support requests.

"lucas sultanum" <lucas.sultanum@gcf.com.br> writes:
> I have been reading a lot about PostGreSQL but until now I haven't
> found anything stating if the PostGreSQL database has any locking
> mechanism. If so, could you send me anithing about this esue??

You evidently did not look very hard:

http://candle.pha.pa.us/main/writings/pgsql/sgml/mvcc.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-lock.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-select.html (look
at the FOR UPDATE clause)

-Neil