Re: review: CHECK FUNCTION statement

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: review: CHECK FUNCTION statement
Дата
Msg-id 27980.1323790650@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: review: CHECK FUNCTION statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: review: CHECK FUNCTION statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2011/12/13 Albe Laurenz <laurenz.albe@wien.gv.at>:
>> Either that, or couldn't you pass an option List as data type "internal"?

> this is question - internal is most simply solution, but then we
> cannot to call check function directly

Yeah, one of the proposals for allowing people to specify complicated
conditions about what to check was to tell them to doselect checker(oid) from pg_proc where any-random-condition;
If the checker isn't user-callable then we lose that escape hatch, and
the only selection conditions that will ever be possible are the ones
we take the trouble to shoehorn into the CHECK FUNCTION statement.
Doesn't seem like a good thing to me.
        regards, tom lane


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

Предыдущее
От: Torello Querci
Дата:
Сообщение: Re: pg_cancel_backend by non-superuser
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: JSON for PG 9.2