Re: BUG #4008: accepts invalid input with domaintypes and outer joins

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4008: accepts invalid input with domaintypes and outer joins
Дата
Msg-id 1431.1204584271@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4008: accepts invalid input with domaintypes and outer joins  ("Robert Fritzsching" <robert.fritzsching@gmx.net>)
Список pgsql-bugs
Дерево обсуждения 
"Robert Fritzsching" <robert.fritzsching@gmx.net> writes:
> If I insert data in a table with left outer join, I get no error even though
> the domain type should trigger an error.

This has been discussed before.  Most of us think it's a bug in the SQL
spec that the issue even exists.  What would you expect to happen with
an outer join that has a not-null-domain output column?

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] Incomplete docs for restore_command for hot standby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore