| 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: | 2003-07-25 07:50:11 |
| Message-ID: | 20030725095011.A13864@nl1.r-kom.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nagy Karoly | 2003-07-25 08:02:11 | PostgreSQL authentication |
| Previous Message | Thomas Kellerer | 2003-07-25 07:30:20 | Re: Which file belongs to which database? |