Re: create rule x as on select...do insert - when?

> Hi all,
> I'm trying to create simple rule:
> nieruchomosci=> create rule log_select as
> on select to oferty do insert into log_oferty (nr) values(oferty.nr);
> ERROR: only instead-select rules currently supported on select
> nieruchomosci=>
>
> pg 6.5.3 on linux, am I forced to create a trigger or is there a simpler
> solution. It is to be a simple rule which is to log to another relation
> information about touples selected in query.
> creating view is not helpfull, because i have to store my data at once in
> log relation not in a view.
>
> any hints?

You cannot log SELECT events, neither with rules nor with
triggers, in Postgres. This feature doesn't exist and isn't
planned.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #