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