[EMAIL PROTECTED] writes:
> So why isn't the AccessShareLock dropped as soon as the SELECT is over?

In general, locks are held till transaction commit.  See any basic
database text for the reasons why this is a good idea.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to