Re: CREATE OR REPLACE FUNCTION vs ownership

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: CREATE OR REPLACE FUNCTION vs ownership
Дата
Msg-id 9138CA43-08B2-439F-8EE4-7018E0DA592C@kineticode.com
обсуждение исходный текст
Ответ на CREATE OR REPLACE FUNCTION vs ownership  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CREATE OR REPLACE FUNCTION vs ownership  (Euler Taveira de Oliveira <euler@timbira.com>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: daveg
Дата:
Сообщение: Re: Postgres server goes in recovery mode repeteadly
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Buffer usage in EXPLAIN and pg_stat_statements (review)