| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Delete denied? |
| Date: | 2003-08-23 01:22:34 |
| Message-ID: | 20030822181933.T2037-100000@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 22 Aug 2003, Josh Berkus wrote:
> Guys:
>
> > Contributing could be that the table holding the deleted records is a child
> > table with an "ON CASCADE DELETE" of one of the tables being updated
> > elsewhere in the function. And the function works if called by the owner of
> > the table (and the function).
>
> Further update: I tried changing the owner of the function and table to no
> avail. Also tried dropping the FK. It seems to work if called by the
> owner of the database, but not otherwise.
It still failed after you dropped the FK (I'd have otherwise agreed with
Tom that there were some cases that I think were broken as recently as
7.3.x for some value of x on permissions)? How much of the definitions
can you let us see?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart | 2003-08-23 03:32:47 | Auto-update a field when record is changed |
| Previous Message | Tom Lane | 2003-08-22 23:55:28 | Re: Delete denied? |