Commitb2b2491

committed

Don't test xmin/xmax columns of a postgres_fdw foreign table.

Their values are unspecified and system-dependent.Per buildfarm member kouprey.

1 parent7cbe57c commitb2b2491Copy full SHA for b2b2491

File tree

-7

lines changed

-7

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -2804,14 +2804,14 @@ NOTICE: trig_row_before(23, skidoo) BEFORE ROW UPDATE ON rem1`
`2804`	`2804`	`NOTICE: OLD: (12,"test triggered !"),NEW: (12,testo)`
`2805`	`2805`	`NOTICE: trig_row_after(23, skidoo) AFTER ROW UPDATE ON rem1`
`2806`	`2806`	`NOTICE: OLD: (12,"test triggered !"),NEW: (12,"testo triggered !")`
`2807`		`--- Test returning systemattributes`
`2808`		`-INSERT INTO rem1(f2) VALUES ('test') RETURNING ctid, xmin, xmax;`
	`2807`	`+-- Test returningasystemattribute`
	`2808`	`+INSERT INTO rem1(f2) VALUES ('test') RETURNING ctid;`
`2809`	`2809`	`NOTICE: trig_row_before(23, skidoo) BEFORE ROW INSERT ON rem1`
`2810`	`2810`	`NOTICE: NEW: (13,test)`
`2811`	`2811`	`NOTICE: trig_row_after(23, skidoo) AFTER ROW INSERT ON rem1`
`2812`	`2812`	`NOTICE: NEW: (13,"test triggered !")`
`2813`		`- ctid\| xmin \| xmax`
`2814`		`---------+------+------------`
`2815`		`- (0,27) \| 180 \| 4294967295`
	`2813`	`+ ctid`
	`2814`	`+--------`
	`2815`	`+ (0,27)`
`2816`	`2816`	`(1 row)`
`2817`	`2817`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -604,5 +604,5 @@ FOR EACH ROW EXECUTE PROCEDURE trig_row_before_insupdate();`
`604`	`604`	`INSERT INTO rem1(f2)VALUES ('test');`
`605`	`605`	`UPDATE rem1SET f2='testo';`
`606`	`606`
`607`		`--- Test returning systemattributes`
`608`		`-INSERT INTO rem1(f2)VALUES ('test') RETURNING ctid, xmin, xmax;`
	`607`	`+-- Test returningasystemattribute`
	`608`	`+INSERT INTO rem1(f2)VALUES ('test') RETURNING ctid;`

Comments

(0)