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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql