Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQjVv-00016Q-KH for pgsql-docs@arkaria.postgresql.org; Thu, 20 Mar 2014 20:24:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WQjVu-0008Nu-Oc for pgsql-docs@arkaria.postgresql.org; Thu, 20 Mar 2014 20:24:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQjVu-0008No-2F for pgsql-docs@postgresql.org; Thu, 20 Mar 2014 20:24:30 +0000 Received: from moutng.kundenserver.de ([212.227.126.131]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQjVm-00036m-T9 for pgsql-docs@postgresql.org; Thu, 20 Mar 2014 20:24:29 +0000 Received: from Macintosh.local (cpe-186-19-70-62.telecentro-reversos.com.ar [186.19.70.62]) by mrelayeu.kundenserver.de (node=mreue001) with ESMTP (Nemesis) id 0LmT7D-1WzF7H2hvP-00aBlI; Thu, 20 Mar 2014 21:24:22 +0100 Message-ID: <532B4E72.90309@2ndquadrant.com> Date: Thu, 20 Mar 2014 17:24:18 -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-docs@postgresql.org Subject: Patch for CREATE RULE sgml Content-Type: multipart/mixed; boundary="------------000908020603040004050405" X-Provags-ID: V02:K0:pmfSKBdX5CBIljW4hkpckwl8qv7oOdAlZALlrX9174T 04Qp2jn6+AYQXhfElD4p2Ns9rlVszoan1YoG00SsMHnZnJx3FR p6RTyH6HtxUdg/q0d79oM4KjaIjy6mD74aWQ7lt2k4sPicqxGU flhZIXM5eKylC/STmnOilRzv3js2wgGbTSEDdQQLNvuIH4gher yMIsxKlkO/FRbusEINbyHNOft7FtooilCJ+IfFcXsXjw/1Lf7s hfLJgX4CAl5OMx6LorUbB5qOxCjvyUFKiWWJr1XXyltZQWTkTe C1BQWEY4Zyx6fjPAxYI9Ls4YFfq/bop/0ZPbAiWHq00IR2NjgX UBWjHtBdx+L23CgYLmFocbTm0RhObxfc2mo2zNZHl X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------000908020603040004050405 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. Regards, - -- - -- Emanuel Calvo Consultant // 2ndQuadrant Bs. As., Argentina // (GMT-3) -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.18 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJTK05yAAoJEIBeI/HMagHmXEkQAJdXdqtPkRi8ZueupUYQxq9+ wJGOeBRGQRYLxZF2n6lqPy789JhjC8n9WyF5/In1zp9LAbbhLXQGaiR+Rueb5Xyv c7m/4+qmrDnds8qTHtNZl7gdDqNm8Qbl8K5/puYKrifBBC6R11HrPiAGckbZuoB9 aO5GJn/qtBNVPDH+1MWhGXu4IRJpFNiH/BW5BD7R3vSMUaO4dbFxE9bmc9seeZL+ 67SSMTANgROsjKkYP/roRRrYyW10AF3/20VLoFdfgYtXRDgo2eBJyR+TokjEhvce h7EOROPpoNFkVHUpaN5UOMYmvlJH+D1IX6pex6nUsQ1YDI0mFJWV+UEKzozC3FO6 BFDRipsrTmzNxo+/BfLsRXhmmiHjaLlsLRZS3aiA41q3BxcbmL7lta4xIdxd+x9T RCHzb96dJqrB2bp9PgaSgH/lxOqTwCQ4rylK3gUOeWpMU8TzLwyuy4bUD2bQYgFj SkLl1aWYTs3WQFPQJ5tO2J3LO6hfvMbxBCAAloeqaghlo2uhnWHQpD+YIMR9/vGx 3bDiVMh2MWWWF4CNe9RQxW5jYwK8JtR79D5u6lNXK4zJ+NYJqYa3kUOprfZnVuM7 pH2EQEnMWQ6PdlSkNv/1lgRBXzb2rynaht9qzsWylhpiieM2+O6w7MsqsPNdPMP7 sii2/ymQmu5yatHo/Mwc =rkEY -----END PGP SIGNATURE----- --------------000908020603040004050405 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} --------------000908020603040004050405 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 --------------000908020603040004050405 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --------------000908020603040004050405--