Re: Allowing NOT IN to use ANTI joins - Mailing list 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