Thread: owner cant delete from table, permission denied

if i try to delete a row from table "customer", it is not permitted
with msg "customer_discount: permission denied", which has foreign key to customer set ON DELETE NO ACTION

- even as the owner of the tables/database owner
- even when all triggers and rules removed on customer_discount

but i am able to delete a row from customer_discount with the same priviliges kept unchanged,

EXPLAIN DELETE FROM customer works,
EXPLAIN ANALYZE DELETE FROM customer fires "customer_discount: permission denied" again

Please can You give me any hint, in which
direction to look for.
IMO, pg_depend (old dependencies) couldnt be the reason, because theres no DROP involved
REINDEX customer* already done without problems, same with VACUUm

postgresql-7.3.2 , data was slurped in from 7.2 few months ago

Thanks for Your efforts,
-- Nico

Nico Latzer <nico.latzer@r-kom.de> writes:
> if i try to delete a row from table "customer", it is not permitted

Perhaps you revoked the owner's delete permission.  See the GRANT and
REVOKE reference pages.

            regards, tom lane

On Thu, 31 Jul 2003, Tom Lane wrote:

> Nico Latzer <nico.latzer@r-kom.de> writes:
> > if i try to delete a row from table "customer", it is not permitted
>
> Perhaps you revoked the owner's delete permission.  See the GRANT and
> REVOKE reference pages.
by setting "references customer on delete set null" the
                                ^^^^^^^^^^
operation succeeded. - previously no "on action" part was defined

priveleges were set sth like
\z customer      public=, group inhouse=arw, db_and_table_owner=ALL
\z customer_xxx  public=, group inhouse=arw, db_and_table_owner=ALL

Thank You

-- Nico