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