Re: Triggers after a rule - Mailing list pgsql-general

From Wijnand Wiersma
Subject Re: Triggers after a rule
Date
Msg-id fb4cc242050928060058114284@mail.gmail.com
Whole thread Raw
In response to Re: Triggers after a rule  (Richard Huxton <dev@archonet.com>)
List pgsql-general
2005/9/28, Richard Huxton <dev@archonet.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

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Problems creating view
Next
From: "William IT"
Date:
Subject: Migration From MS SQL 2K