Re: Allowing NOT IN to use ANTI joins

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Allowing NOT IN to use ANTI joins
Дата
Msg-id 53959FAE.50709@dalibo.com
обсуждение исходный текст
Ответ на Allowing NOT IN to use ANTI joins  (David Rowley <dgrowleyml@gmail.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Supporting Windows SChannel as OpenSSL replacement
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Supporting Windows SChannel as OpenSSL replacement