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/
