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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Fritzsching" <robert(dot)fritzsching(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4008: accepts invalid input with domaintypes and outer joins
Date: 2008-03-03 22:44:31
Message-ID: 1431.1204584271@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Robert Fritzsching" <robert(dot)fritzsching(at)gmx(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-03-03 23:39:50 Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore
Previous Message Bruce Momjian 2008-03-03 21:14:02 Re: [PATCHES] Incomplete docs for restore_command for hot standby