val@webtribe.net wrote:
> Hi all;
>
> Is it possible to write a trigger or the ilk that would disallow
> direct inserts, updates, or deletes to a table unless it was
> being executed through a function? How can I identify that the
> DML being issued is being done via a function?
http://www.postgresql.org/docs/7.4/static/sql-createfunction.html
Look for security definer. Grant table access only to user who creates the
function and grant access to function to everybody concerned.
HTH
Shridhar
