On Thu, Oct 4, 2012 at 6:12 AM, Ivan Voras
<ivoras@freebsd.org> wrote:
On 01/10/2012 15:36, Moshe Jacobson wrote:
> I am working on an audit logging trigger that gets called for every row
> inserted, updated or deleted on any table.
> For this, I need to store a couple of temporary session variables such as
> the ID of the user performing the change, which can be set at the start of
> the session.
Do you know about session variables?
The major benefit here is that it doesn't touch the table engines,
temporary or not.
This sounds incredibly useful. Why have I not heard of this until today??
In your example you still had to use a BEGIN...EXCEPTION block. Is that faster than a create temp table?
--
Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer
