On Tue, Feb 25, 2020 at 1:54 AM Laurenz Albe wrote:
> I am not sure if CREATE TABLE is the perfect place; another place that
> would offer ifself is
> https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-FK
> ,
> where foreign key constraints are explained.
I had found th
I was planning to add a new table TA only writable by user A, with a
foreign key reference with ON DELETE CASCADE to another table TB only
writable by user B. My hope was that user B would still be allowed to
delete rows in TB and cause cascading deletions in table TA, and some
manual investigatio