Commits

Simon Riggs  committed ddf509e

Tweak tests in COPY FREEZE

  • Participants
  • Parent commits 8de72b6

Comments (0)

Files changed (2)

File src/test/regress/expected/copy2.out

 (2 rows)
 
 COMMIT;
+BEGIN;
 TRUNCATE vistest;
 COPY vistest FROM stdin CSV FREEZE;
-NOTICE:  FREEZE option specified but pre-conditions not met
 SELECT * FROM vistest;
  a 
 ---
- a
- b
+ x
+ y
 (2 rows)
 
+COMMIT;
+TRUNCATE vistest;
+COPY vistest FROM stdin CSV FREEZE;
+NOTICE:  FREEZE option specified but pre-conditions not met
 BEGIN;
 INSERT INTO vistest VALUES ('z');
 SAVEPOINT s1;
 SELECT * FROM vistest;
  a 
 ---
- a
- b
+ p
+ g
  z
  d
  e
 (2 rows)
 
 DROP TABLE vistest;
+DROP FUNCTION truncate_in_subxact();
 DROP TABLE x, y;
 DROP FUNCTION fn_x_before();
 DROP FUNCTION fn_x_after();

File src/test/regress/sql/copy2.sql

 SAVEPOINT s1;
 TRUNCATE vistest;
 ROLLBACK TO SAVEPOINT s1;
--- FREEZE should be silently ignored here
 COPY vistest FROM stdin CSV FREEZE;
 d
 e