Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group