"Perry Smith" <pedz@easesoftware.com> writes:
> Looking at the documentation above, I would expect the insert into A to get a
> Row exclusive lock for table A. And, I'm guessing it would get an ACCESS
> SHARE lock for table B. But this would not prevent the delete from B from
> happening at the same time (if I am reading this correctly).
The bit you quoted was for tables. The RI trigger does indeed take a share
lock on the referenced record in table B which prevents it from being deleted.
(In older versions it used to take an exclusive lock because there were no
share locks on records.)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
