Re: owner cant delete from table, permission denied

On Thu, 31 Jul 2003, Tom Lane wrote:

> Nico Latzer <nico(dot)latzer(at)r-kom(dot)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