Re: Allowing NOT IN to use ANTI joins

Vik Fearing <vik.fearing@dalibo.com>

From: Vik Fearing <vik.fearing@dalibo.com>
To: David Rowley <dgrowleyml@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2014-06-09T11:51:10Z
Lists: pgsql-hackers
On 06/08/2014 02:36 PM, David Rowley wrote:
> +		if (!get_attnotnull(tle->resorigtbl, tle->resorigcol))
> +			return false;

As Marti says, you can't do this because NOT NULL doesn't have an oid to
attach a dependency to.  You'll have to restrict this test to primary
keys only for now.
-- 
Vik