X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3BBC0D1BA42 for ; Fri, 22 Aug 2003 20:55:33 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 02728-10 for ; Fri, 22 Aug 2003 20:55:31 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 41A4BD1BA2A for ; Fri, 22 Aug 2003 20:55:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7MNtT5H011257; Fri, 22 Aug 2003 19:55:29 -0400 (EDT) To: josh@agliodbs.com Cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: Delete denied? In-reply-to: <200308221624.13158.josh@agliodbs.com> References: <200308221624.13158.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Fri, 22 Aug 2003 16:24:13 -0700" Date: Fri, 22 Aug 2003 19:55:28 -0400 Message-ID: <11256.1061596528@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/281 X-Sequence-Number: 14897 Josh Berkus 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