Is it possible to have a cascade upwards query?

From: Mike Martin <redtux1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it possible to have a cascade upwards query?
Date: 2019-03-27 15:58:10
Message-ID: CAOwYNKaPAx20Vdwu+Kch6uw6NKYAtGvCKjNBbD-9E6U3pGNMcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-27 16:15:15 Re: Is it possible to have a cascade upwards query?
Previous Message Prakash Ramakrishnan 2019-03-27 15:32:48 Re: plctl extension issue postgresql 11.2