| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Why is lock not released? |
| Date: | 2005-08-19 16:14:33 |
| Message-ID: | 20050819161433.GA14344@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
I notice ATExecChangeOwner uses a different mechanism, but it still
locks the relation until transaction end.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Ni aun el genio muy grande llegaría muy lejos
si tuviera que sacarlo todo de su propio interior" (Goethe)
| Attachment | Content-Type | Size |
|---|---|---|
| schemacmds.patch | text/plain | 495 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-08-19 16:48:46 | SetOf Functions |
| Previous Message | Stephan Szabo | 2005-08-19 15:12:08 | Re: [GENERAL] Cascades Failing |