Re: Declaring a strict function returns not null / eval speed

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: Declaring a strict function returns not null / eval speed
Дата
Msg-id 20191022191845.GC4495@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: Declaring a strict function returns not null / eval speed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Re: Tom Lane 2019-10-22 <821.1571771210@sss.pgh.pa.us>
> Actually, I think we probably don't need any SQL representation of this
> at all, because if what you're going to do with it is omit logically
> necessary null-value checks, then a wrong setting would trivially crash
> the server.  Therefore, we can never give the ability to set this flag
> to users; we could only set it on built-in functions.

Or require superuser.

> This doesn't seem too awful to me, because non-builtin functions are
> most likely slow enough that it doesn't matter.

Some years ago, Kohsuke Kawaguchi, the Jenkins author, was giving a
keynote at FOSDEM about extensibility of software. The gist I took
away from it was the tagline "if core can do something that extensions
can't, that's a bug". I think that's something that PostgreSQL should
try to live up to as well.

Christoph



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Declaring a strict function returns not null / eval speed
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Declaring a strict function returns not null / eval speed