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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Pantelis Theodosiou <ypercube(at)gmail(dot)com>
Cc: porton(at)narod(dot)ru, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION
Date: 2021-07-07 00:09:56
Message-ID: CAKFQuwYsRq=Px1ttzRJB-z21UL_LVumVZHSNFUVoA=iS2zbScQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jul 6, 2021 at 5:05 PM Pantelis Theodosiou <ypercube(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Victor Porton 2021-07-07 00:33:49 Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION
Previous Message Pantelis Theodosiou 2021-07-07 00:04:52 Re: BUG #17085: Should be able to create an index without referential checking when ON DELETE NO ACTION