Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>> Now that we have Statement-level triggers, is there any reason we shouldn't
>> have triggers on SELECT?
>
> Plenty, although I'm too tired to recall 'em all. The fundamental
> problem with this is that it turns SELECT into an operation with
> side-effects.
The other fundamental problem is the definition of SELECT. To show just
one of the 273 possible problems:
UPDATE sometab SET foo = 'bar' WHERE NOT EXISTS (SELECT 1 FROM othertab WHERE o_id = s_id);
Now explain in detail what the ON SELECT trigger on othertab will be
fired for.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #