Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WR1np-0003hY-8Y for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Mar 2014 15:56:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WR1no-0002xL-Mh for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Mar 2014 15:56:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WR1nm-0002uz-5k for pgsql-hackers@postgresql.org; Fri, 21 Mar 2014 15:56:10 +0000 Received: from moutng.kundenserver.de ([212.227.126.187]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WR1nh-0007Sm-Uw for pgsql-hackers@postgresql.org; Fri, 21 Mar 2014 15:56:09 +0000 Received: from Macintosh.local (81-159-18-190.fibertel.com.ar [190.18.159.81]) by mrelayeu.kundenserver.de (node=mreue006) with ESMTP (Nemesis) id 0MGL3r-1WMLEx22cB-00FEvK; Fri, 21 Mar 2014 16:56:05 +0100 Message-ID: <532C6111.4040102@2ndquadrant.com> Date: Fri, 21 Mar 2014 12:56:01 -0300 From: Emanuel Calvo User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:24.0) Gecko/20100101 Thunderbird/24.3.0 MIME-Version: 1.0 To: "pgsql-hackers@postgresql.org" Subject: Patch for CREATE RULE sgml -- Was in: [DOCS] References: <532B4E72.90309@2ndquadrant.com> In-Reply-To: <532B4E72.90309@2ndquadrant.com> X-Enigmail-Version: 1.6 X-Forwarded-Message-Id: <532B4E72.90309@2ndquadrant.com> Content-Type: multipart/mixed; boundary="------------030204090309010304000409" X-Provags-ID: V02:K0:iO1d54KJp1ADLGVgxPUlPcc564lbqZhKdfgJllsqQ4+ 0sr11+yezrtRAjOuhNnFqQO+VEK6WR24tn+8x0wymPmTRb1P76 dU0N9IgFpH9JwanM9YIr4+fc2uBRG5QnRF2WC/yAMEj4C5l3A4 2Em4igyqKyE+o+Nz92BQAeKj83h4GMwe77a3e3X1GgilXIkQxy 1YLKcE6hF9xwswtYYqSrsxAI2gdcOo2I6fEAxE+qbMrSjjoXx1 c74PYw4hTqoEuA6WJrkTv8g07Zzu6B+2bEeoesQm1Z/cSWXQvj bdV7R7jMrMldUez2HLmA6/JiD4n+E3TzXJiV6CnkEGIqXemb7C Udk0stVsK/4mxj/Mb+KQ10HNo/8ARKnPlnbC4ZjbW X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------030204090309010304000409 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi guys, I realized that the output of the CREATE RULE has not a detailed output for the "events" parameter. But the question here is that I'm not sure which format follow: { INSERT | UPDATE | DELETE | SELECT} or INSERT UPDATE DELETE SELECT - -- I attach a patch for each one. I sent a mail to pgsql-docs but no response has been received. Thanks and regards, -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.18 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJTLGERAAoJEIBeI/HMagHmUYcP/ibZQaTYDgLmclqgv6wbeTnT m9d9mhYEJVhdyowGcJ5s+OSCN5tj2vGJifjxUAQ+6hW+0mzj9kqQLoWJyb9DYn1o AbbUM6+p2Q1+P5KAUYMVZDRiGN6EqFPw2BgsXhIA2rXHT/PiSPpKvFK6wQ0rmSyX houtfrXEl4zzLHyrmHZmWHyz6DgPyTM/jtHTd/yhAl1OxKR5V583bHEfDUz3zYEX v6NjBiq5TY6uaXVF0B0cya8nRfW3KP240cwZTF5zRoyHZ1LNlHLPEPs2huNZPLbk tp3UIHhdiZKl7ddJcWTTeuv4ABQXQVBLQwHWR91szMr+dz/Wsk0zmeFNzlCKCzzN cehz5n6yewIiosS1MlD7lxOAHPN0yiXtsjiOWoQYbLaxkcTO74oUZK1iWXD025TB vSegM0L1a1GJFNjyZhQnUgMLWELhsC5y1g7Pn7D9YkzeyicEFtFRTkGDR9eh9LmV PNtV4w5M/hZtbappfoW7IL6tLtZnjHUA+UjPflnoae0uQ8G+MOW+3rkXt30BksdR VXvbhXTXaKLj2cEs8cfyBuVUs8AwBGssjfX2OxkSYjvGYcHVoSN/o0cqOWUD/mMi 98ORZcLrzWk70kQ0zxW9wIXbkp4M+8uogyzL9ViveiLREHYD9SRlWMGPpgbcs/aM fB7fgznJGvXZoRefJKdQ =UWLa -----END PGP SIGNATURE----- --------------030204090309010304000409 Content-Type: text/x-diff; name="add_events_on_create_rule.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="add_events_on_create_rule.patch" diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index d3212b5..22b46e2 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -24,6 +24,9 @@ PostgreSQL documentation CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } + +where event can be one of: + { INSERT | UPDATE | DELETE | SELECT} --------------030204090309010304000409 Content-Type: text/x-diff; name="add_events_on_create_rule_2.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="add_events_on_create_rule_2.patch" diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index d3212b5..a4df024 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -24,6 +24,12 @@ PostgreSQL documentation CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } + +where event can be one of: + INSERT + UPDATE + DELETE + SELECT --------------030204090309010304000409 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------030204090309010304000409--