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"
/* ^^^ */
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 tuple of the
* rewritten relation. This restricts SELECT rules to views.
elog(ERROR, "attribute level rules currently not
In result on all query, where after "ON" we put something as
Postgres answer :ERROR: "attribute level rules currently not supported"
But in docs
CREATE RULE name AS ON event
TO object [ WHERE condition ]
DO [ INSTEAD ] [ action | NOTHING ]
Object is either table or table.column.
И необходимость в таких правилах есть.
In baglist-е (todo) i dont found anything about this trouble.
This code,doc don't rewriten 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.....
pgsql-hackers by date
|Next:||From: Kevin O'Gorman||Date: 2000-10-26 18:53:47|
|Subject: Re: [GENERAL] A rare error|
|Previous:||From: Larry Rosenman||Date: 2000-10-26 18:42:29|
|Subject: Re: Idea: cross-check versions during initdb|
pgsql-interfaces by date
|Next:||From: Joseph Shraibman||Date: 2000-10-26 20:42:54|
|Subject: Re: XML Support in Postgres|
|Previous:||From: Adam Lang||Date: 2000-10-26 17:38:03|
|Subject: Re: new maintainer for the ODBC driver?|