Simple question about Postgress rule system and docs for it .

From: Vic <vic(at)dcc(dot)dp(dot)ua>
To: lockhart(at)alumni(dot)caltech(dot)edu
Cc: JanWieck(at)yahoo(dot)com, pgsql-interfaces(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Simple question about Postgress rule system and docs for it .
Date: 2000-10-26 18:46:07
Message-ID: 39F87BEF.FA8C05D8@dcc.dp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

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 tuple of 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 ON event
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'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.....
Vic

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin O'Gorman 2000-10-26 18:53:47 Re: [GENERAL] A rare error
Previous Message Larry Rosenman 2000-10-26 18:42:29 Re: Idea: cross-check versions during initdb

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joseph Shraibman 2000-10-26 20:42:54 Re: XML Support in Postgres
Previous Message Adam Lang 2000-10-26 17:38:03 Re: new maintainer for the ODBC driver?