Commitfff518d

committed

Revert "Suppress DETAIL output from a foreign_data test."

This should be superseded by commit8aa9dd7.

1 parent03ae9d5 commitfff518dCopy full SHA for fff518d

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -439,11 +439,10 @@ GRANT USAGE ON FOREIGN DATA WRAPPER foo TO regress_test_indirect;`
`439`	`439`	`SET ROLE regress_test_role;`
`440`	`440`	`ALTER SERVER s1 OWNER TO regress_test_indirect;`
`441`	`441`	`RESET ROLE;`
`442`		`--- We use terse mode to avoid ordering issues in detail output.`
`443`		`-\set VERBOSITY terse`
`444`	`442`	`DROP ROLE regress_test_indirect; -- ERROR`
`445`	`443`	`ERROR: role "regress_test_indirect" cannot be dropped because some objects depend on it`
`446`		`-\set VERBOSITY default`
	`444`	`+DETAIL: privileges for foreign-data wrapper foo`
	`445`	`+owner of server s1`
`447`	`446`	`\des+`
`448`	`447`	`List of foreign servers`
`449`	`448`	`Name \| Owner \| Foreign-data wrapper \| Access privileges \| Type \| Version \| FDW options \| Description`
`@@ -1204,6 +1203,7 @@ ERROR: permission denied for foreign-data wrapper foo`
`1204`	`1203`	`ALTER SERVER s9 VERSION '1.1';`
`1205`	`1204`	`GRANT USAGE ON FOREIGN SERVER s9 TO regress_test_role;`
`1206`	`1205`	`CREATE USER MAPPING FOR current_user SERVER s9;`
	`1206`	`+-- We use terse mode to avoid ordering issues in cascade detail output.`
`1207`	`1207`	`\set VERBOSITY terse`
`1208`	`1208`	`DROP SERVER s9 CASCADE;`
`1209`	`1209`	`NOTICE: drop cascades to 2 other objects`

Lines changed: 1 addition & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -199,10 +199,7 @@ GRANT USAGE ON FOREIGN DATA WRAPPER foo TO regress_test_indirect;`
`199`	`199`	`SET ROLE regress_test_role;`
`200`	`200`	`ALTER SERVER s1 OWNER TO regress_test_indirect;`
`201`	`201`	`RESET ROLE;`
`202`		`--- We use terse mode to avoid ordering issues in detail output.`
`203`		`-\set VERBOSITY terse`
`204`	`202`	`DROP ROLE regress_test_indirect;-- ERROR`
`205`		`-\set VERBOSITY default`
`206`	`203`	`\des+`
`207`	`204`
`208`	`205`	`ALTER SERVER s8 RENAME to s8new;`
`@@ -504,6 +501,7 @@ CREATE SERVER s10 FOREIGN DATA WRAPPER foo; -- ERROR`
`504`	`501`	`ALTER SERVER s9 VERSION'1.1';`
`505`	`502`	`GRANT USAGEON FOREIGN SERVER s9 TO regress_test_role;`
`506`	`503`	`CREATEUSERMAPPING FORcurrent_user SERVER s9;`
	`504`	`+-- We use terse mode to avoid ordering issues in cascade detail output.`
`507`	`505`	`\set VERBOSITY terse`
`508`	`506`	`DROP SERVER s9 CASCADE;`
`509`	`507`	`\set VERBOSITY default`

Comments

(0)