Postgres Pro
Downloads
Home   >   mailing lists

Re: why is there no TRIGGER ON SELECT ? - Mailing list pgsql-general

From Melvin Davidson
Subject Re: why is there no TRIGGER ON SELECT ?
Date
Msg-id 943294.93531.qm@web121808.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: why is there no TRIGGER ON SELECT ?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: why is there no TRIGGER ON SELECT ?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: why is there no TRIGGER ON SELECT ?  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Tree view
Dmitriy

>Why not use function which returns table and wrap the
>logging (auditing) code in it ?

Because to use a trigger function, you need a trigger, and as previously stated, you cannot have a trigger on select. The same applies for a rule.

Melvin Davidson



pgsql-general by date:

Previous
From: Geoffrey Myers
Date:
Subject: Re: disable triggers using psql
Next
From: Dmitriy Igrishin
Date:
Subject: Re: why is there no TRIGGER ON SELECT ?