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