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 F3425D1BA5C for ; Fri, 22 Aug 2003 20:51:56 -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 02656-10 for ; Fri, 22 Aug 2003 20:51:54 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id E8346D1BA42 for ; Fri, 22 Aug 2003 20:51:45 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3540465; Fri, 22 Aug 2003 16:50:02 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: Delete denied? Date: Fri, 22 Aug 2003 16:48:14 -0700 User-Agent: KMail/1.4.3 References: <200308221624.13158.josh@agliodbs.com> In-Reply-To: <200308221624.13158.josh@agliodbs.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200308221648.14119.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/280 X-Sequence-Number: 14896 Guys: > Contributing could be that the table holding the deleted records is a chi= ld=20 > table with an "ON CASCADE DELETE" of one of the tables being updated=20 > elsewhere in the function. And the function works if called by the owner= of=20 > the table (and the function). Further update: I tried changing the owner of the function and table to no= =20 avail. Also tried dropping the FK. It seems to work if called by the=20 owner of the database, but not otherwise. I'm really baffled ... I've written several hundred procedures for 7.2.4, a= nd=20 have never seen anything like this. --=20 -Josh Berkus Aglio Database Solutions San Francisco