Message-ID: <39F87BEF.FA8C05D8@dcc.dp.ua>
Date: Thu, 26 Oct 2000 21:46:07 +0300
From: Vic <vic@dcc.dp.ua>
Organization: DCC
MIME-Version: 1.0
To: lockhart@alumni.caltech.edu
CC: JanWieck@yahoo.com, pgsql-interfaces@postgresql.org,
	pgsql-hackers@postgresql.org
Subject: Simple question about Postgress rule system and docs for  it .
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit

 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