*** /home/pavel/src/postgresql/src/test/regress/expected/temp.out 2013-12-01 07:50:55.748792948 +0100 --- /home/pavel/src/postgresql/src/test/regress/results/temp.out 2014-06-24 18:10:45.636027420 +0200 *************** *** 95,116 **** COMMIT; SELECT * FROM temptest; ! ERROR: relation "temptest" does not exist ! LINE 1: SELECT * FROM temptest; ! ^ BEGIN; CREATE TEMP TABLE temptest(col) ON COMMIT DROP AS SELECT 1; SELECT * FROM temptest; col ----- 1 ! (1 row) - COMMIT; - SELECT * FROM temptest; - ERROR: relation "temptest" does not exist - LINE 1: SELECT * FROM temptest; - ^ -- ON COMMIT is only allowed for TEMP CREATE TABLE temptest(col int) ON COMMIT DELETE ROWS; ERROR: ON COMMIT can only be used on temporary tables --- 95,119 ---- COMMIT; SELECT * FROM temptest; ! col ! ----- ! 1 ! 2 ! (2 rows) ! BEGIN; CREATE TEMP TABLE temptest(col) ON COMMIT DROP AS SELECT 1; + ERROR: relation "temptest" already exists + SELECT * FROM temptest; + ERROR: current transaction is aborted, commands ignored until end of transaction block + COMMIT; SELECT * FROM temptest; col ----- 1 ! 2 ! (2 rows) -- ON COMMIT is only allowed for TEMP CREATE TABLE temptest(col int) ON COMMIT DELETE ROWS; ERROR: ON COMMIT can only be used on temporary tables ======================================================================