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