Re: CREATE OR REPLACE FUNCTION vs ownership

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: CREATE OR REPLACE FUNCTION vs ownership
Date: 2009-10-01 23:52:18
Message-ID: 9138CA43-08B2-439F-8EE4-7018E0DA592C@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Oct 1, 2009, at 3:42 PM, Tom Lane wrote:

> My inclination is to think that the right behavior for REPLACE
> FUNCTION
> is to keep the old proowner and proacl values, because that's what it
> always has done and nobody's complained. But I suppose a case could
> be made that you're completely replacing the function and so you
> should
> replace its ownership/permissions too. The CREATE FUNCTION reference
> page fails to specify either way, which is a documentation bug as
> well.
>
> Comments?

The latter, I think. If I replace a function, I should be the new
owner. To me it makes no sense for someone else to own it.

Best,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2009-10-02 00:32:06 Re: Buffer usage in EXPLAIN and pg_stat_statements (review)
Previous Message daveg 2009-10-01 23:51:10 Re: Postgres server goes in recovery mode repeteadly