| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Delete denied? |
| Date: | 2003-08-22 23:55:28 |
| Message-ID: | 11256.1061596528@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 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).
I seem to recall that the original coding of the RI triggers was
careless about executing the RI operations as the "right" user (namely
the table owner). This very possibly was still broken in 7.2.4.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-23 01:22:34 | Re: Delete denied? |
| Previous Message | Josh Berkus | 2003-08-22 23:48:14 | Re: Delete denied? |