Re: [SQL] Delete failing with -- permission denied

anand086 <anand086@gmail.com> writes:
> Delete from table test.entities_all is failing with "permission denied for
> relation". The table from which row has to be deleted, is referenced by
> another table "attribute_types" with ON DELETE CASCADE.

> I tried deleting the row from attribute_types table and then deleting from
> test.entities_all succeed.

Probably you have permissions to do such deletion, but the owner of the
entities_all table does not.  FK CASCADE queries are run as the owner
of the table in question.
        regards, tom lane