Re: owner cant delete from table, permission denied - Mailing list pgsql-general

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