Re: Need help extripating plpgsql

"James B. Byrne" <byrnejb(at)harte-lyne(dot)ca> writes:
> If all the elements contained in the standard templates had their
> ownerships changed to that of the owner of the new database then my
> problem would never have arisen. I do not understand why this is not
> the case. Is there a reason why this is so?

I don't see why you expect that. Should a non-superuser database owner
have the ability to redefine, say, sum(int4)? You might as well just
give him superuser privileges.

In PG's security model, ownership of a database does *not* automatically
confer any privileges with respect to the contained objects. It doesn't
really give much at all except the ability to drop or rename the
database as a whole.

regards, tom lane