Re: [HACKERS] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Tom Lane wrote: > > Bruce Momjian writes: > > > >> One problem is that because system oids are used, it isn't possible to > >> drop the language: > >> I assume we still want to allow the language to be uninstalled, for > >> security purposes. > >> > > > > Yes.

Re: [HACKERS] Installing PL/pgSQL by default

2009-12-03 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian writes: One problem is that because system oids are used, it isn't possible to drop the language: I assume we still want to allow the language to be uninstalled, for security purposes. Yes. That behavior is not acceptable. Why aren't you just adding a

Re: [HACKERS] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > One problem is that because system oids are used, it isn't possible to > > drop the language: > > I assume we still want to allow the language to be uninstalled, for > > security purposes. > > Yes. That behavior is not acceptable. Why aren't you just

Re: [HACKERS] Installing PL/pgSQL by default

2009-12-03 Thread Tom Lane
Bruce Momjian writes: > One problem is that because system oids are used, it isn't possible to > drop the language: > I assume we still want to allow the language to be uninstalled, for > security purposes. Yes. That behavior is not acceptable. Why aren't you just adding a CREATE LANGUAGE call

[HACKERS] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
Tom Lane wrote: > But actually I thought we had more or less concluded that CREATE OR > REPLACE LANGUAGE would be acceptable (perhaps only if it's given > without any extra args?). Or for that matter there seems to be enough > opinion on the side of just installing plpgsql by default. CINE is > a