Re: [SQL] Delete denied?

2003-08-23 Thread Jeff Eckermann
--- Josh Berkus <[EMAIL PROTECTED]> wrote: > 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".

Re: [SQL] Delete denied?

2003-08-22 Thread Stephan Szabo
On Fri, 22 Aug 2003, Josh Berkus wrote: > Guys: > > > 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

Re: [SQL] Delete denied?

2003-08-22 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> 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 functio

Re: [SQL] Delete denied?

2003-08-22 Thread Josh Berkus
Guys: > 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). Further update: I tried cha

[SQL] Delete denied?

2003-08-22 Thread Josh Berkus
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 r