8000 Revert "Fix regression tests" · johto/postgres@59941f0 · GitHub
[go: up one dir, main page]
Skip to content

Commit 59941f0

Browse files
johtojohto
committed
Revert "Fix regression tests"
This reverts commit b12367e.
1 parent b12367e commit 59941f0

File tree

10 files changed

+78
-599
lines changed

10 files changed

+78
-599
lines changed

‎src/test/regress/expected/alter_table.out

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -361,14 +361,11 @@ CREATE FUNCTION boo(int) RETURNS int IMMUTABLE STRICT LANGUAGE plpgsql AS $$ BEG
361361
INSERT INTO tmp7 VALUES (8, 18);
362362
ALTER TABLE tmp7 ADD CONSTRAINT identity CHECK (b = boo(b));
363363
NOTICE: boo: 18
364-
CONTEXT: PL/pgSQL function boo(integer) line 1 at RAISE
365364
ALTER TABLE tmp3 ADD CONSTRAINT IDENTITY check (b = boo(b)) NOT VALID;
366365
NOTICE: merging constraint "identity" with inherited definition
367366
ALTER TABLE tmp3 VALIDATE CONSTRAINT identity;
368367
NOTICE: boo: 16
369-
CONTEXT: PL/pgSQL function boo(integer) line 1 at RAISE
370368
NOTICE: boo: 20
371-
CONTEXT: PL/pgSQL function boo(integer) line 1 at RAISE
372369
-- Try (and fail) to create constraint from tmp5(a) to tmp4(a) - unique constraint on
373370
-- tmp4 is a,b
374371
ALTER TABLE tmp5 add constraint tmpconstr foreign key(a) references tmp4(a) match full;

‎src/test/regress/expected/event_trigger.out

Lines changed: 1 addition & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -70,13 +70,10 @@ alter event trigger regress_event_trigger disable;
7070
-- regress_event_trigger
7171
create table event_trigger_fire1 (a int);
7272
NOTICE: test_event_trigger: ddl_command_start CREATE TABLE
73-
CONTEXT: PL/pgSQL function test_event_trigger() line 3 at RAISE
7473
NOTICE: test_event_trigger: ddl_command_end CREATE TABLE
75-
CONTEXT: PL/pgSQL function test_event_trigger() line 3 at RAISE
7674
-- regress_event_trigger_end should fire here
7775
drop table event_trigger_fire1;
7876
NOTICE: test_event_trigger: ddl_command_end DROP TABLE
79-
CONTEXT: PL/pgSQL function test_event_trigger() line 3 at RAISE
8077
-- alter owner to non-superuser should fail
8178
alter event trigger regress_event_trigger owner to regression_bob;
8279
ERROR: permission denied to change owner of event trigger "regress_event_trigger"
@@ -197,8 +194,7 @@ PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE statement
197194
SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three"
198195
PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE statement
199196
ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped
200-
CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE
201-
SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three"
197+
CONTEXT: SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three"
202198
PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE statement
203199
DELETE FROM undroppable_objs WHERE object_identity = 'audit_tbls.schema_two_table_three';
204200
DROP SCHEMA schema_one, schema_two CASCADE;
@@ -228,7 +224,6 @@ NOTICE: table "schema_one_table_three" does not exist, skipping
228224
CONTEXT: SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_one_table_three"
229225
PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE statement
230226
ERROR: object schema_one.table_three of type table cannot be dropped
231-
CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE
232227
DELETE FROM undroppable_objs WHERE object_identity = 'schema_one.table_three';
233228
DROP SCHEMA schema_one, schema_two CASCADE;
234229
NOTICE: drop cascades to 7 other objects

‎src/test/regress/expected/plancache.out

Lines changed: 0 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -237,11 +237,8 @@ NOTICE: table "temptable" does not exist, skipping
237237
CONTEXT: SQL statement "drop table if exists temptable cascade"
238238
PL/pgSQL function cachebug() line 4 at SQL statement
239239
NOTICE: 1
240-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
241240
NOTICE: 2
242-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
243241
NOTICE: 3
244-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
245242
cachebug
246243
----------
247244

@@ -252,11 +249,8 @@ NOTICE: drop cascades to view vv
252249
CONTEXT: SQL statement "drop table if exists temptable cascade"
253250
PL/pgSQL function cachebug() line 4 at SQL statement
254251
NOTICE: 1
255-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
256252
NOTICE: 2
257-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
258253
NOTICE: 3
259-
CONTEXT: PL/pgSQL function cachebug() line 8 at RAISE
260254
cachebug
261255
----------
262256

0 commit comments

Comments
 (0)
0