Fix hot standby tests for sequence catalog change

petere · petere · commit 3d54c16c24d7 · 2017-01-03T09:27:43.000-05:00
From: Kuntal Ghosh &lt;kuntalghosh.2007@gmail.com&gt;
diff --git a/src/test/regress/expected/hs_standby_allowed.out b/src/test/regress/expected/hs_standby_allowed.out
@@ -26,7 +26,7 @@ COPY hs1 TO '/tmp/copy_test';
 \! cat /tmp/copy_test
 1
 -- Access sequence directly
-select min_value as sequence_min_value from hsseq;
+select min_value as sequence_min_value from pg_sequences where sequencename = 'hsseq';
  sequence_min_value 
 --------------------
                   1
diff --git a/src/test/regress/sql/hs_standby_allowed.sql b/src/test/regress/sql/hs_standby_allowed.sql
@@ -16,7 +16,7 @@ COPY hs1 TO '/tmp/copy_test';
 \! cat /tmp/copy_test
 
 -- Access sequence directly
-select min_value as sequence_min_value from hsseq;
+select min_value as sequence_min_value from pg_sequences where sequencename = 'hsseq';
 
 -- Transactions
 

Original file line number	Diff line number	Diff line change
`@@ -26,7 +26,7 @@ COPY hs1 TO '/tmp/copy_test';`
`26`	`26`	`\! cat /tmp/copy_test`
`27`	`27`	`1`
`28`	`28`	`-- Access sequence directly`
`29`		`-select min_value as sequence_min_value from hsseq;`
	`29`	`+select min_value as sequence_min_value from pg_sequences where sequencename = 'hsseq';`
`30`	`30`	`sequence_min_value`
`31`	`31`	`--------------------`
`32`	`32`	`1`