Commit82433e9

committed

Update a couple of example error messages to reflect the fact that we

don't generate constraint names like "$1" anymore.

1 parentc71e3de commit82433e9Copy full SHA for 82433e9

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.42 2004/08/01 17:32:11 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.43 2004/08/07 19:53:48 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="tutorial-advanced">`
`@@ -123,7 +123,7 @@ INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28');`
`123`	`123`	`</programlisting>`
`124`	`124`
`125`	`125`	`<screen>`
`126`		`-ERROR: insert or update on table "weather" violates foreign key constraint "$1"`
	`126`	`+ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"`
`127`	`127`	`DETAIL: Key (city)=(Berkeley) is not present in table "cities".`
`128`	`128`	`</screen>`
`129`	`129`	`</para>`
`@@ -290,6 +290,7 @@ COMMIT;`
`290`	`290`	`Remembering the bank database, suppose we debit $100.00 from Alice's`
`291`	`291`	`account, and credit Bob's account, only to find later that we should`
`292`	`292`	`have credited Wally's account. We could do it using savepoints like`
	`293`	`+ this:`
`293`	`294`
`294`	`295`	`<programlisting>`
`295`	`296`	`BEGIN;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.27 2004/08/03 20:32:30 tgl Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.28 2004/08/07 19:53:48 tgl Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="ddl">`
`4`	`4`	`<title>Data Definition</title>`
`@@ -1971,7 +1971,7 @@ REVOKE CREATE ON SCHEMA public FROM PUBLIC;`
`1971`	`1971`	`<screen>`
`1972`	`1972`	`DROP TABLE products;`
`1973`	`1973`
`1974`		`-NOTICE: constraint$1 on table orders depends on table products`
	`1974`	`+NOTICE: constraintorders_product_no_fkey on table orders depends on table products`
`1975`	`1975`	`ERROR: cannot drop table products because other objects depend on it`
`1976`	`1976`	`HINT: Use DROP ... CASCADE to drop the dependent objects too.`
`1977`	`1977`	`</screen>`

Comments

(0)