Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION
Дата
Msg-id CAKFQuwYsRq=Px1ttzRJB-z21UL_LVumVZHSNFUVoA=iS2zbScQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION  (Pantelis Theodosiou <ypercube@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jul 6, 2021 at 5:05 PM Pantelis Theodosiou <ypercube@gmail.com> wrote:
 
Transactions is referenced twice, once without correlation and secondly with correlation.
 

Yeah, the USING clause of DELETE is basically an INNER JOIN.  If you need an ANTI-JOIN you can write that via NOT EXISTS just like you would in a normal SELECT query.  You don't get the option to write an anti-join using a left join and testing for null.

David J.

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

Предыдущее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION
Следующее
От: Victor Porton
Дата:
Сообщение: Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION