Alvaro Herrera <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend