Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-docs-owner+M7605=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UDOfv-0000A5-S7
	for pgsql-docs@arkaria.postgresql.org; Thu, 07 Mar 2013 00:27:12 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-docs-owner+M7605=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UDOfu-0006Py-No
	for pgsql-docs@arkaria.postgresql.org; Thu, 07 Mar 2013 00:27:10 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <barwick@gmail.com>)
	id 1UDOft-0006Pq-Ny; Thu, 07 Mar 2013 00:27:10 +0000
Received: from mail-ia0-x229.google.com ([2607:f8b0:4001:c02::229])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <barwick@gmail.com>)
	id 1UDOfr-0005o2-Px; Thu, 07 Mar 2013 00:27:08 +0000
Received: by mail-ia0-f169.google.com with SMTP id j5so8089305iaf.28
	for <multiple recipients>; Wed, 06 Mar 2013 16:27:06 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=mime-version:x-received:date:message-id:subject:from:to
	:content-type; bh=9SFBYiS8fbpoljvngS3GfUC21gI9JhxRfJ2/64g/zJI=;
	b=ARFmK90EKWEO9SuzsWL41JaBvsizf9T1PeSBVlmPyAhEgbc9utnnu+T8Z1bCQzR8YL
	oUtDq3l8N7mH/3uxMNrW7kY0utfWTw1b12NYGInQTnYGMTU2ZayiTaXqJMwk3pVIvbPs
	/+M227TrVxxg9Zb//f1Xc+f26aJaNfxcHVO6wq/L80yipXEuizhCf262k91l7o5+Vl6O
	+jGgiojIptFdLttL6y3NfPxxlAln9qBS0xqW65oGMnGehWWiKx8tVpETH0P+zL9xMMiQ
	Fl6YA5Hlh9TRm+3qr3KDyi7dQwBy+u8+semLPNkOv6hbN6WruXDXsSejXkVyufEMXtu1
	2aAw==
MIME-Version: 1.0
X-Received: by 10.50.237.70 with SMTP id va6mr13114254igc.66.1362616026701;
	Wed, 06 Mar 2013 16:27:06 -0800 (PST)
Received: by 10.50.106.166 with HTTP; Wed, 6 Mar 2013 16:27:06 -0800 (PST)
Date: Thu, 7 Mar 2013 09:27:06 +0900
Message-ID: 
 <CAB8KJ=infML6Ac9VAt_FjOvsN5hv=ZW+gGC7kR-XsMfzPvi=sQ@mail.gmail.com>
Subject: Small patch for "CREATE TRIGGER" documentation
From: Ian Lawrence Barwick <barwick@gmail.com>
To: pgsql-docs <pgsql-docs@postgresql.org>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary=f46d044786f33ca79404d74ac4a9
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


--f46d044786f33ca79404d74ac4a9
Content-Type: text/plain; charset=UTF-8

I found this sentence somewhat confusing:

"It is possible for a column's value to change even when the trigger
is not fired,"

http://www.postgresql.org/docs/devel/static/sql-createtrigger.html#SQL-CREATETRIGGER-NOTES

More precise would be something along the lines "It is possible that
changes to the
column's value will not cause the trigger to be fired".

The attached patch hopefully rewords the entire paragraph for clarity.

Regards

Ian Barwick

--f46d044786f33ca79404d74ac4a9
Content-Type: application/octet-stream;
	name="create-trigger-doc-notes-2013-03-07.patch"
Content-Disposition: attachment;
	filename="create-trigger-doc-notes-2013-03-07.patch"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_hdz5zyd80

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RyaWdnZXIu
c2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RyaWdnZXIuc2dtbApu
ZXcgZmlsZSBtb2RlIDEwMDY0NAppbmRleCBkOTgxN2U0Li4zN2QzMzlkCioq
KiBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RyaWdnZXIuc2dtbAotLS0g
Yi9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90cmlnZ2VyLnNnbWwKKioqKioq
KioqKioqKioqIFVQREFURSBPRiA8cmVwbGFjZWFibGU+Y29sdW1uX25hbWUx
PC9yZXAKKioqIDM3NCwzODUgKioqKgogICAgIEEgY29sdW1uLXNwZWNpZmlj
IHRyaWdnZXIgKG9uZSBkZWZpbmVkIHVzaW5nIHRoZSA8bGl0ZXJhbD5VUERB
VEUgT0YKICAgICA8cmVwbGFjZWFibGU+Y29sdW1uX25hbWU8L3JlcGxhY2Vh
YmxlPjwvbGl0ZXJhbD4gc3ludGF4KSB3aWxsIGZpcmUgd2hlbiBhbnkKICAg
ICBvZiBpdHMgY29sdW1ucyBhcmUgbGlzdGVkIGFzIHRhcmdldHMgaW4gdGhl
IDxjb21tYW5kPlVQREFURTwvPgohICAgIGNvbW1hbmQncyA8bGl0ZXJhbD5T
RVQ8Lz4gbGlzdC4gIEl0IGlzIHBvc3NpYmxlIGZvciBhIGNvbHVtbidzIHZh
bHVlCiEgICAgdG8gY2hhbmdlIGV2ZW4gd2hlbiB0aGUgdHJpZ2dlciBpcyBu
b3QgZmlyZWQsIGJlY2F1c2UgY2hhbmdlcyBtYWRlIHRvIHRoZQohICAgIHJv
dydzIGNvbnRlbnRzIGJ5IDxsaXRlcmFsPkJFRk9SRSBVUERBVEU8Lz4gdHJp
Z2dlcnMgYXJlIG5vdCBjb25zaWRlcmVkLgohICAgIENvbnZlcnNlbHksIGEg
Y29tbWFuZCBzdWNoIGFzIDxsaXRlcmFsPlVQREFURSAuLi4gU0VUIHggPSB4
IC4uLjwvPgohICAgIHdpbGwgZmlyZSBhIHRyaWdnZXIgb24gY29sdW1uIDxs
aXRlcmFsPng8Lz4sIGV2ZW4gdGhvdWdoIHRoZSBjb2x1bW4ncwohICAgIHZh
bHVlIGRpZCBub3QgY2hhbmdlLgogICAgPC9wYXJhPgogIAogICAgPHBhcmE+
Ci0tLSAzNzQsMzg0IC0tLS0KICAgICBBIGNvbHVtbi1zcGVjaWZpYyB0cmln
Z2VyIChvbmUgZGVmaW5lZCB1c2luZyB0aGUgPGxpdGVyYWw+VVBEQVRFIE9G
CiAgICAgPHJlcGxhY2VhYmxlPmNvbHVtbl9uYW1lPC9yZXBsYWNlYWJsZT48
L2xpdGVyYWw+IHN5bnRheCkgd2lsbCBmaXJlIHdoZW4gYW55CiAgICAgb2Yg
aXRzIGNvbHVtbnMgYXJlIGxpc3RlZCBhcyB0YXJnZXRzIGluIHRoZSA8Y29t
bWFuZD5VUERBVEU8Lz4KISAgICBjb21tYW5kJ3MgPGxpdGVyYWw+U0VUPC8+
IGxpc3QuIE5vdGUgdGhhdCB0aGUgdHJpZ2dlciB3aWxsIGZpcmUgZXZlbiBp
ZiB0aGUgCiEgICAgc3BlY2lmaWVkIGNvbHVtbidzIHZhbHVlIGRpZCBub3Qg
Y2hhbmdlLCBmb3IgZXhhbXBsZSB3aGVuIGlzc3VpbmcgYSBjb21tYW5kIAoh
ICAgIHN1Y2ggYXMgPGxpdGVyYWw+VVBEQVRFIC4uLiBTRVQgeCA9IHggLi4u
PC8+LiBIb3dldmVyLCBjaGFuZ2VzIG1hZGUgdG8gdGhlCiEgICAgc3BlY2lm
aWVkIGNvbHVtbiBieSBhbnkgPGxpdGVyYWw+QkVGT1JFIFVQREFURTwvPiB0
cmlnZ2VycyB3aWxsIG5vdCBjYXVzZQohICAgIHRoZSB0cmlnZ2VyIHRvIGZp
cmUuCiAgICA8L3BhcmE+CiAgCiAgICA8cGFyYT4K

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

--f46d044786f33ca79404d74ac4a9--