Hello!
Its, may be ,little "gluk" in doc, - sources and docs and examples
for Create Rule not correlated. Conctrento :)) -> В доке ->CREATE RULE example_1 AS ON UPDATE emp.salary WHERE
old.name= "Joe" /* ^^^ */ DO UPDATE emp SET salary = new.salary WHERE emp.name =
"Sam";
/* ^^^ - its maby type-bUg -> ON UPDATE TO )*/
And in sources........ /* ---------- * The current rewrite handler is known to work on relation level
*rules only. And for SELECT events, it expects one non-nothing * action that is instead and returns exactly a
tupleof the * rewritten relation. This restricts SELECT rules to views. * * Jan *
---------- */ if (event_obj->attrs) elog(ERROR, "attribute level rules currently not
supported");In result on all query, where after "ON" we put something as
"emp.salary" ,Postgres answer :ERROR: "attribute level rules currently not supported" But in docs CREATE RULE name AS
ONevent TO object [ WHERE condition ] DO [ INSTEAD ] [ action | NOTHING ]..........
where --> object Object is either table or table.column. ^^^^^^^^^^^^^!!!!! 8-()И
необходимость в таких правилах есть.In baglist-е (todo) i dont found anything about this trouble.This code,doc
don'trewriten from version 6.4 - i diggin in several Suse Linux - distrib,sourses dowloaded from
www.postgressql.org, and again see all aviable
docs about rules.
Waiting for any help.... ;)
Sorry ,pls for my dirty english..... Vic