Dimitri Fontaine <dimi...@2ndquadrant.fr> writes: > Tom Lane <t...@sss.pgh.pa.us> writes: >> You'd need to work out how the CREATE OR REPLACE and DROP cases would >> work.
> Maybe the fever ain't gone far enough, but I'd just do nothing in the > first case and internally cascade to the extension in the second case. > In fact internally the drop case would be redirected on the extension > and the dependencies would get rid of the PL, right? Not sure it's that easy. I think DROP LANGUAGE can't assume that the language it's been told to drop is extension-ified. (Even if we do this for all the core ones, there are a dozen non-core ones that might not all get with the program right away.) How do we make this work in a way that covers both cases, but doesn't turn DROP LANGUAGE into a security hole that lets non-superusers drop random extensions? It may all work pretty easily, but I'm still caffeine-deprived so I'm not sure ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers