Re: Triggers with DO functionality - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Triggers with DO functionality
Date
Msg-id 1330111403.32452.19.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Triggers with DO functionality  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Triggers with DO functionality  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On fre, 2012-02-17 at 16:46 -0500, Tom Lane wrote:
> But perhaps SECURITY DEFINER is a common enough need to justify
> including in this shorthand form.

According to the SQL standard, trigger actions run in security definer
mode.  I would hope that we could go with that by default for inline
trigger actions, because it's the thing that makes sense for triggers
most of the time anyway, I think.




pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: Patch: add timing of buffer I/O requests
Next
From: Peter Eisentraut
Date:
Subject: Re: Fix PL/Python metadata when there is no result