Stephan, Tom:
Hey, I have a function which can involve some records being deleted at the
end. The user calling the function has permission to delete records (and
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 function,
but this is on 7.2.4.
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).
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
