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