On Fri, Feb 24, 2012 at 2:55 PM, Kevin Grittner
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> By default, a trigger function runs as the table owner, ie it's
> implicitly SEC DEF
>> to the table owner.
> Really? That's certainly what I would *want*, but it's not what I've
Yeah, not quite consistent with what I've seen.
And it's not obvious that it truly is what you want. An audit trigger
would need to run as the *audit table* owner, which might not be the
same as the user that owns the table on which the trigger fires.
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"
In response to
pgsql-hackers by date
|Next:||From: amit sehas||Date: 2012-02-24 20:45:41|
|Subject: Behavior of subselects in target lists and order by|
|Previous:||From: Kevin Grittner||Date: 2012-02-24 19:55:01|
|Subject: Re: Triggers with DO functionality|