Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

owner cant delete from table, permission denied


  • From: Nico Latzer <nico(dot)latzer(at)r-kom(dot)de>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: owner cant delete from table, permission denied
  • Date: Fri, 25 Jul 2003 09:50:11 +0200
  • Message-id: <20030725095011.A13864@nl1.r-kom.de> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group