Horton
Menu

Re: PGXS: REGRESS_OPTS=--load-language=plpgsql

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: David Christensen <david@endpoint.com>, Bruce Momjian <bruce@momjian.us>, "David E. Wheeler" <david@kineticode.com>, Dimitri Fontaine <dfontaine@hi-media.com>, Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>, David Fetter <david@fetter.org>, Euler Taveira de Oliveira <euler@timbira.com>, PG Hackers <pgsql-hackers@postgresql.org>
Date: 2010-02-21T22:11:16Z
Lists: pgsql-hackers 
Robert Haas <robertmhaas@gmail.com> writes:
> On Sun, Feb 21, 2010 at 1:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It will be owned by the bootstrap superuser, so the case is exactly
>> the one that a non-superuser DBA would be faced with.

> Or even a superuser other than the bootstrap superuser, no?  I dump
> out the DB on my 8.4 server and try to reload on 9.0 with --single and
> it fails because, even though I'm a superuser, I can't replace a
> language owned by someone else?

No, superusers always pass all permissions checks.

			regards, tom lane