regression.diffs

application/octet-stream

Filename: regression.diffs
Type: application/octet-stream
Part: 0
Message: Re: [HACKERS] generated columns
diff -U3 /home/pavel/src/postgresql.master/contrib/dblink/expected/dblink.out /home/pavel/src/postgresql.master/contrib/dblink/results/dblink.out
--- /home/pavel/src/postgresql.master/contrib/dblink/expected/dblink.out	2019-03-02 17:00:24.472460214 +0100
+++ /home/pavel/src/postgresql.master/contrib/dblink/results/dblink.out	2019-03-26 19:46:27.161403374 +0100
@@ -984,23 +984,21 @@
 	ADD COLUMN col4 INT NOT NULL DEFAULT 42;
 SELECT dblink_build_sql_insert('test_dropped', '1', 1,
                                ARRAY['1'::TEXT], ARRAY['2'::TEXT]);
-                          dblink_build_sql_insert                          
----------------------------------------------------------------------------
- INSERT INTO test_dropped(id,col2b,col3,col4) VALUES('2','113','foo','42')
-(1 row)
-
+ERROR:  column "........pg.dropped.1........" does not exist
+LINE 1: SELECT "........pg.dropped.1........", id, "........pg.dropp...
+               ^
+QUERY:  SELECT "........pg.dropped.1........", id, "........pg.dropped.3........", col2b, col3, col4 FROM test_dropped WHERE "........pg.dropped.1........" = '1'
 SELECT dblink_build_sql_update('test_dropped', '1', 1,
                                ARRAY['1'::TEXT], ARRAY['2'::TEXT]);
-                                  dblink_build_sql_update                                  
--------------------------------------------------------------------------------------------
- UPDATE test_dropped SET id = '2', col2b = '113', col3 = 'foo', col4 = '42' WHERE id = '2'
-(1 row)
-
+ERROR:  column "........pg.dropped.1........" does not exist
+LINE 1: SELECT "........pg.dropped.1........", id, "........pg.dropp...
+               ^
+QUERY:  SELECT "........pg.dropped.1........", id, "........pg.dropped.3........", col2b, col3, col4 FROM test_dropped WHERE "........pg.dropped.1........" = '1'
 SELECT dblink_build_sql_delete('test_dropped', '1', 1,
                                ARRAY['2'::TEXT]);
-         dblink_build_sql_delete         
------------------------------------------
- DELETE FROM test_dropped WHERE id = '2'
+                       dblink_build_sql_delete                       
+---------------------------------------------------------------------
+ DELETE FROM test_dropped WHERE "........pg.dropped.1........" = '2'
 (1 row)
 
 -- test local mimicry of remote GUC values that affect datatype I/O