Re: Triggers after a rule

From: Wijnand Wiersma <wwiersma(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers after a rule
Date: 2005-09-28 13:00:41
Message-ID: fb4cc242050928060058114284@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2005/9/28, Richard Huxton <dev(at)archonet(dot)com>:
> The solution is to mark your trigger functions with the "SECURITY
> DEFINER" attribute and create them as a user who can access relation
> "contact".
> http://www.postgresql.org/docs/8.0/static/sql-createfunction.html

Damn, I really really missed that one :-(
Thank you very much Richard!

Wijnand

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2005-09-28 13:18:15 Re: trigger self recursion
Previous Message Sim Zacks 2005-09-28 12:20:57 Re: trigger self recursion