Re: Bug#347548: DOMAIN CHECK constraint bypassed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug#347548: DOMAIN CHECK constraint bypassed
Дата
Msg-id 19098.1138476644@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug#347548: DOMAIN CHECK constraint bypassed  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
Peter Eisentraut <peter_e@gmx.net> writes:
> This bug was reported to Debian.  Comments?

These are all known issues.  The implementation of domains really needs
rather a lot of work :-(.

One thing we might think about is having domain types use a special set
of input functions rather than just linking directly to the base-type
functions (kinda like arrays use array_in, etc).  These functions could
then be charged with applying the appropriate constraint checks after
invoking the correct base-type input function.  I'm not sure about
performance issues (ie, how to avoid repetitive lookups and memory
leaks) but at least we'd only need to solve it in one place and not
several.

            regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Bug#347548: DOMAIN CHECK constraint bypassed
Следующее
От: "Nicholas"
Дата:
Сообщение: BUG #2218: Variables selected in VIEWs under different names break queries using those views