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

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

From
M.Mazurek@poznan.multinet.pl
Date:
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?



Marcin Mazurek

--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/


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

From
wieck@debis.com (Jan Wieck)
Date:
> 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@debis.com (Jan Wieck) #