Postgres Pro
Downloads
Home   >   mailing lists

FK cascade delete permissions Q - Mailing list pgsql-admin

From Wells Oliver
Subject FK cascade delete permissions Q
Date
Msg-id CAOC+FBVeRVSabhyVGOgR3pfgpGAme6n6FLybwu913AZdR-ROgw@mail.gmail.com
Whole thread Raw
Responses Re: FK cascade delete permissions Q
List pgsql-admin
Tree view
I have a user who created a table B with an FK constraint to table A with CASCADE DELETE, but receives a permission denied error on A.

It seems odd to me. The FK constraint is not deleting from A, it's ensuring a delete from B, for which the user has permission.

What am I missing?

--

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
Next
From: "David G. Johnston"
Date:
Subject: Re: FK cascade delete permissions Q