Re: Why is lock not released? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why is lock not released?
Date
Msg-id 26028.1124471514@sss.pgh.pa.us
Whole thread Raw
In response to Why is lock not released?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Why is lock not released?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I just noticed that AlterSchemaOwner (and others like AlterFunctionOwner
> -- I haven't checked anything else yet) does not release the lock on
> pg_namespace (resp. AlterFunctionOwner) after it's done changing it.  Is
> there a reason for this?

The code's a bit inconsistent about whether it releases non-exclusive
locks on system catalogs or leaves them till transaction end.  I suppose
sometime we should try to make it consistent --- but as long as you're
talking about non-exclusive locks, it doesn't really matter too much.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: SetOf Functions
Next
From: "Chuck McDevitt"
Date:
Subject: Re: Windows + IP6 progress