On 2000-01-13, Gabriel Fernandez mentioned:
> - What does exactly mean that a mode 'CONFLICTS' with another
> ?
> - Does it mean that another concurrent transactions having
> these modes will have to wait until the first transaction
> have finished (commit or roll back) ?
Yes. You can try that pretty easily. Start up two psqls, in the first one
enter:
BEGIN TRANSACTION;
LOCK pg_class IN ACCESS EXCLUSIVE MODE;
In the second one enter:
SELECT * FROM pg_class;
The latter will hang.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
