> 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. # #========================================= [EMAIL PROTECTED] (Jan Wieck) #