ATET, could it be made "more concurrent" ? - Mailing list pgsql-general

From Sahagian, David
Subject ATET, could it be made "more concurrent" ?
Date
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D0109E60C99@MX22A.corp.emc.com
Whole thread Raw
List pgsql-general
PostgreSQL 9.1.x

I try to enable my trigger
  "ALTER TABLE cool_tbl ENABLE TRIGGER trg_for_cool_tbl;"

I notice that it gets blocked by another backend doing
  "select xxx from cool_tbl;"
(of course, my pain is if this transaction lasts for minutes, instead of se=
conds)

I understand that [postgresql.org/docs/9.1/static/explicit-locking.html] te=
lls us
The request for "AccessExclusiveLock" on relation R will be blocked by the =
existing "AccessShareLock" on relation R.

But I cannot reconcile that with . . .

How could doing ENABLE of a trigger hurt the transaction that has thus far =
only done a SELECT on the table ?

Thanks for your insight,
-dvs-

pgsql-general by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
Next
From: Leonardo M. Ramé
Date:
Subject: Re: Parsing COPY ... WITH BINARY