Simple question about Postgress rule system and docs for it .
От | Vic |
---|---|
Тема | Simple question about Postgress rule system and docs for it . |
Дата | |
Msg-id | 39F87BEF.FA8C05D8@dcc.dp.ua обсуждение исходный текст |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: