Re: Misunderstanding transactions and locks - Mailing list pgsql-general

From Michael P. Soulier
Subject Re: Misunderstanding transactions and locks
Date
Msg-id 20100618020809.GU26066@e-smith.com
Whole thread Raw
In response to Re: Misunderstanding transactions and locks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 16/06/10 Tom Lane did say:

> > "row exclusive mode" does not block itself.
>
> Specifically, see the table in
> http://www.postgresql.org/docs/8.3/static/explicit-locking.html#LOCKING-TABLES
>
> Exclusive lock modes are those that conflict with themselves; to wit,
> SHARE ROW EXCLUSIVE mode or higher.  The mode names are, um, historical.

That explains much.

Thanks,
Mike
--
Michael P. Soulier <michael_soulier@mitel.com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einstein

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: UUID/GUID
Next
From: "Joshua D. Drake"
Date:
Subject: Re: postgres crash SOS