Home > mailing lists

Is it possible to have a cascade upwards query? - Mailing list pgsql-general

From	Mike Martin
Subject	Is it possible to have a cascade upwards query?
Date	March 27, 2019 18:58:10
Msg-id	CAOwYNKaPAx20Vdwu+Kch6uw6NKYAtGvCKjNBbD-9E6U3pGNMcA@mail.gmail.com Whole thread Raw
Responses	Re: Is it possible to have a cascade upwards query? (Adrian Klaver <adrian.klaver@aklaver.com>) Re: Is it possible to have a cascade upwards query? ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-general

As per title, is this possible?

Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table

I would like to have the record in table two deleted when I delete the record in table 1

Thanks

From: Prakash Ramakrishnan
Date: 27 March 2019, 18:32:48
Subject: Re: plctl extension issue postgresql 11.2

From: Adrian Klaver
Date: 27 March 2019, 19:15:15
Subject: Re: Is it possible to have a cascade upwards query?