Re: System triggers

Sailesh Krishnamurthy <sailesh@cs.berkeley.edu> writes:

> >>>>> "Doug" == Doug McNaught <doug@mcnaught.org> writes:
> 
>     Doug> Of course, what happens to the output (if any) from those
>     Doug> triggers, given that the client probably doesn't expect it,
>     Doug> is an interesting question...
> 
> What are the actions of pgsql triggers ? I would have thought they
> result in Update/Delete/Insert operations on other tables. Why should
> that result in output for any client ? 

They still (IIRC) return results (like 'INSERT 1 10002') to the
client end of the connection, and there's no a-priori reason they
couldn't do SELECTS as well...

-Doug