Re: BUG #4008: accepts invalid input with domaintypes and outer joins - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4008: accepts invalid input with domaintypes and outer joins
Date
Msg-id 1431.1204584271@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4008: accepts invalid input with domaintypes and outer joins  ("Robert Fritzsching" <robert.fritzsching@gmx.net>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Incomplete docs for restore_command for hot standby
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore