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
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 |
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? |