Re: Problem with delete trigger: how to allow only triggers to delete a row? - Mailing list pgsql-sql

Christopher Maier wrote:

> Correct?  That sounds like it would work.  If at all possible, I'd like 
> to keep the "interface" the same for all my tables, though (i.e., users 
> don't have to be concerned with whether they can do regular SQL deletes, 
> or if they have to call a special function).

Hmm, maybe you can turn a regular DELETE into a function call by using
an INSTEAD rule, but I'm not sure.  That way they would just do a plain
DELETE and the sec-def function would be called instead.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support