Re: create rule x as on select...do insert - when? - Mailing list pgsql-general

> 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) #