| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Thom Brown <thombrown(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Subject: | Re: [HACKERS] Installing PL/pgSQL by default |
| Date: | 2009-12-04 15:29:10 |
| Message-ID: | 24775.1259940550@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Tom> Hm, I think that's only a problem if we define it to be a
> Tom> problem, and I'm not sure it's necessary to do so.
> The complaint is that if plpgsql is installed by default, then it will
> be owned by postgres rather than by the db owner, who will then not be
> able to drop it or use grant/revoke on it.
Right, just like every other thing that's pre-installed. If a
particular installation wishes to let individual DB owners control this,
the superuser can drop plpgsql from template1. It's not apparent to me
why we need to allow non-superusers to override the project's decisions
about what should be installed by default.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2009-12-04 16:36:00 | PostgreSQL Release Support Policy |
| Previous Message | Cjkalbente | 2009-12-04 15:08:16 | Re: Daily migration on Postgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2009-12-04 15:29:21 | Re: Hot Standby remaining issues |
| Previous Message | Jeff | 2009-12-04 15:19:53 | Re: First feature patch for plperl - draft [PATCH] |