Commit13ea825

committed

Spell "explicitly" correctly, per Simon.

1 parent823702b commit13ea825Copy full SHA for 13ea825

File tree

-9

lines changed

-9

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group`
`8`	`8`	`* Portions Copyright (c) 1994, Regents of the University of California`
`9`	`9`	`*`
`10`		`- * $PostgreSQL: pgsql/src/include/nodes/parsenodes.h,v 1.297 2005/11/28 04:35:32 tgl Exp $`
	`10`	`+ * $PostgreSQL: pgsql/src/include/nodes/parsenodes.h,v 1.298 2005/12/07 15:20:55 tgl Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -660,8 +660,8 @@ typedef enum SetOperation`
`660`	`660`
`661`	`661`	`typedefenumContainsOids`
`662`	`662`	`{`
`663`		`-MUST_HAVE_OIDS,/* WITH OIDSexplicitely specified */`
`664`		`-MUST_NOT_HAVE_OIDS,/* WITHOUT OIDSexplicitely specified */`
	`663`	`+MUST_HAVE_OIDS,/* WITH OIDSexplicitly specified */`
	`664`	`+MUST_NOT_HAVE_OIDS,/* WITHOUT OIDSexplicitly specified */`
`665`	`665`	`DEFAULT_OIDS/* neither specified; use the default, which`
`666`	`666`	`* is the value of the default_with_oids GUC`
`667`	`667`	`* var */`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -970,7 +970,7 @@ drop table pktable_base;`
`970`	`970`	`-- Deferrable constraints`
`971`	`971`	`--(right now, only FOREIGN KEY constraints can be deferred)`
`972`	`972`	`--`
`973`		`--- deferrable,explicitely deferred`
	`973`	`+-- deferrable,explicitly deferred`
`974`	`974`	`CREATE TABLE pktable (`
`975`	`975`	`idINT4 PRIMARY KEY,`
`976`	`976`	`otherINT4`
`@@ -985,7 +985,7 @@ NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fktable_pkey" fo`
`985`	`985`	`INSERT INTO fktable VALUES (5, 10);`
`986`	`986`	`ERROR: insert or update on table "fktable" violates foreign key constraint "fktable_fk_fkey"`
`987`	`987`	`DETAIL: Key (fk)=(10) is not present in table "pktable".`
`988`		`---explicitely defer the constraint`
	`988`	`+--explicitly defer the constraint`
`989`	`989`	`BEGIN;`
`990`	`990`	`SET CONSTRAINTS ALL DEFERRED;`
`991`	`991`	`INSERT INTO fktable VALUES (10, 15);`
`@@ -1008,7 +1008,7 @@ BEGIN;`
`1008`	`1008`	`INSERT INTO fktable VALUES (100, 200);`
`1009`	`1009`	`INSERT INTO pktable VALUES (200, 500); -- make the FK insert valid`
`1010`	`1010`	`COMMIT;`
`1011`		`--- default to deferred,explicitely make immediate`
	`1011`	`+-- default to deferred,explicitly make immediate`
`1012`	`1012`	`BEGIN;`
`1013`	`1013`	`SET CONSTRAINTS ALL IMMEDIATE;`
`1014`	`1014`	`-- should fail`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -599,7 +599,7 @@ drop table pktable_base;`
`599`	`599`	`--(right now, only FOREIGN KEY constraints can be deferred)`
`600`	`600`	`--`
`601`	`601`
`602`		`--- deferrable,explicitely deferred`
	`602`	`+-- deferrable,explicitly deferred`
`603`	`603`	`CREATETABLEpktable (`
`604`	`604`	`idINT4PRIMARY KEY,`
`605`	`605`	`otherINT4`
`@@ -613,7 +613,7 @@ CREATE TABLE fktable (`
`613`	`613`	`-- default to immediate: should fail`
`614`	`614`	`INSERT INTO fktableVALUES (5,10);`
`615`	`615`
`616`		`---explicitely defer the constraint`
	`616`	`+--explicitly defer the constraint`
`617`	`617`	`BEGIN;`
`618`	`618`
`619`	`619`	`SET CONSTRAINTS ALL DEFERRED;`
`@@ -644,7 +644,7 @@ INSERT INTO pktable VALUES (200, 500); -- make the FK insert valid`
`644`	`644`
`645`	`645`	`COMMIT;`
`646`	`646`
`647`		`--- default to deferred,explicitely make immediate`
	`647`	`+-- default to deferred,explicitly make immediate`
`648`	`648`	`BEGIN;`
`649`	`649`
`650`	`650`	`SET CONSTRAINTS ALL IMMEDIATE;`

Comments

(0)