Content-Type: text/plain;
  charset="us-ascii"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Stephan Szabo <sszabo@megazone.bigpanda.com>,
	pgsql-sql@postgresql.org
Subject: Delete denied?
Date: Fri, 22 Aug 2003 16:24:13 -0700
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200308221624.13158.josh@agliodbs.com>

Stephan, Tom:

Hey, I have a function which can involve some records being deleted at the=
=20
end.   The user calling the function has permission to delete records (and=
=20
I've tested this), but when I run the function I get "permission denied".

Any clue?  I remember in 7.1.x that you couldn't delete records in a functi=
on,=20
but this is on 7.2.4.=20=20=20

Contributing could be that the table holding the deleted records is a child=
=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 o=
f=20
the table (and the function).

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco