Re: Need help extripating plpgsql

"James B. Byrne" <byrnejb@harte-lyne.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