NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit3a0939e

committed

Update standbycheck test output with new ERROR message changes. No changes

to tests and no changes in accepted server behaviour.

1 parentabeb17c commit3a0939eCopy full SHA for 3a0939e

File tree

2 files changed

+31

-31

lines changed

src/test/regress/expected
- hs_standby_disallowed.out
- hs_standby_functions.out

2 files changed

+31

-31

lines changed

`‎src/test/regress/expected/hs_standby_disallowed.out`

Lines changed: 30 additions & 30 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,40 +11,40 @@ commit;`
`11`	`11`	`WARNING: there is no transaction in progress`
`12`	`12`	`-- SELECT`
`13`	`13`	`select * from hs1 FOR SHARE;`
`14`		`-ERROR:transaction isread-only`
	`14`	`+ERROR:cannot execute SELECT FOR SHARE in aread-only transaction`
`15`	`15`	`select * from hs1 FOR UPDATE;`
`16`		`-ERROR:transaction isread-only`
	`16`	`+ERROR:cannot execute SELECT FOR UPDATE in aread-only transaction`
`17`	`17`	`-- DML`
`18`	`18`	`BEGIN;`
`19`	`19`	`insert into hs1 values (37);`
`20`		`-ERROR:transaction isread-only`
	`20`	`+ERROR:cannot execute INSERT in aread-only transaction`
`21`	`21`	`ROLLBACK;`
`22`	`22`	`BEGIN;`
`23`	`23`	`delete from hs1 where col1 = 1;`
`24`		`-ERROR:transaction isread-only`
	`24`	`+ERROR:cannot execute DELETE in aread-only transaction`
`25`	`25`	`ROLLBACK;`
`26`	`26`	`BEGIN;`
`27`	`27`	`update hs1 set col1 = NULL where col1 > 0;`
`28`		`-ERROR:transaction isread-only`
	`28`	`+ERROR:cannot execute UPDATE in aread-only transaction`
`29`	`29`	`ROLLBACK;`
`30`	`30`	`BEGIN;`
`31`	`31`	`truncate hs3;`
`32`		`-ERROR:transaction isread-only`
	`32`	`+ERROR:cannot execute TRUNCATE TABLE in aread-only transaction`
`33`	`33`	`ROLLBACK;`
`34`	`34`	`-- DDL`
`35`	`35`	`create temporary table hstemp1 (col1 integer);`
`36`		`-ERROR:transaction isread-only`
	`36`	`+ERROR:cannot execute CREATE TABLE in aread-only transaction`
`37`	`37`	`BEGIN;`
`38`	`38`	`drop table hs2;`
`39`		`-ERROR:transaction isread-only`
	`39`	`+ERROR:cannot execute DROP TABLE in aread-only transaction`
`40`	`40`	`ROLLBACK;`
`41`	`41`	`BEGIN;`
`42`	`42`	`create table hs4 (col1 integer);`
`43`		`-ERROR:transaction isread-only`
	`43`	`+ERROR:cannot execute CREATE TABLE in aread-only transaction`
`44`	`44`	`ROLLBACK;`
`45`	`45`	`-- Sequences`
`46`	`46`	`SELECT nextval('hsseq');`
`47`		`-ERROR: cannotbe executed during recovery`
	`47`	`+ERROR: cannotexecute nextval() in a read-only transaction`
`48`	`48`	`-- Two-phase commit transaction stuff`
`49`	`49`	`BEGIN;`
`50`	`50`	`SELECT count(*) FROM hs1;`
`@@ -54,7 +54,7 @@ SELECT count(*) FROM hs1;`
`54`	`54`	`(1 row)`
`55`	`55`
`56`	`56`	`PREPARE TRANSACTION 'foobar';`
`57`		`-ERROR: cannotbe executed during recovery`
	`57`	`+ERROR: cannotexecute PREPARE TRANSACTION during recovery`
`58`	`58`	`ROLLBACK;`
`59`	`59`	`BEGIN;`
`60`	`60`	`SELECT count(*) FROM hs1;`
`@@ -64,7 +64,7 @@ SELECT count(*) FROM hs1;`
`64`	`64`	`(1 row)`
`65`	`65`
`66`	`66`	`COMMIT PREPARED 'foobar';`
`67`		`-ERROR: cannotbe executed during recovery`
	`67`	`+ERROR:COMMIT PREPAREDcannotrun inside a transaction block`
`68`	`68`	`ROLLBACK;`
`69`	`69`	`BEGIN;`
`70`	`70`	`SELECT count(*) FROM hs1;`
`@@ -74,7 +74,7 @@ SELECT count(*) FROM hs1;`
`74`	`74`	`(1 row)`
`75`	`75`
`76`	`76`	`PREPARE TRANSACTION 'foobar';`
`77`		`-ERROR: cannotbe executed during recovery`
	`77`	`+ERROR: cannotexecute PREPARE TRANSACTION during recovery`
`78`	`78`	`ROLLBACK PREPARED 'foobar';`
`79`	`79`	`ERROR: current transaction is aborted, commands ignored until end of transaction block`
`80`	`80`	`ROLLBACK;`
`@@ -86,52 +86,52 @@ SELECT count(*) FROM hs1;`
`86`	`86`	`(1 row)`
`87`	`87`
`88`	`88`	`ROLLBACK PREPARED 'foobar';`
`89`		`-ERROR: cannotbe executed during recovery`
	`89`	`+ERROR:ROLLBACK PREPAREDcannotrun inside a transaction block`
`90`	`90`	`ROLLBACK;`
`91`	`91`	`-- Locks`
`92`	`92`	`BEGIN;`
`93`	`93`	`LOCK hs1;`
`94`		`-ERROR: cannotbe executed during recovery`
	`94`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`95`	`95`	`COMMIT;`
`96`	`96`	`BEGIN;`
`97`	`97`	`LOCK hs1 IN SHARE UPDATE EXCLUSIVE MODE;`
`98`		`-ERROR: cannotbe executed during recovery`
	`98`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`99`	`99`	`COMMIT;`
`100`	`100`	`BEGIN;`
`101`	`101`	`LOCK hs1 IN SHARE MODE;`
`102`		`-ERROR: cannotbe executed during recovery`
	`102`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`103`	`103`	`COMMIT;`
`104`	`104`	`BEGIN;`
`105`	`105`	`LOCK hs1 IN SHARE ROW EXCLUSIVE MODE;`
`106`		`-ERROR: cannotbe executed during recovery`
	`106`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`107`	`107`	`COMMIT;`
`108`	`108`	`BEGIN;`
`109`	`109`	`LOCK hs1 IN EXCLUSIVE MODE;`
`110`		`-ERROR: cannotbe executed during recovery`
	`110`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`111`	`111`	`COMMIT;`
`112`	`112`	`BEGIN;`
`113`	`113`	`LOCK hs1 IN ACCESS EXCLUSIVE MODE;`
`114`		`-ERROR: cannotbe executed during recovery`
	`114`	`+ERROR: cannotexecute LOCK TABLE during recovery`
`115`	`115`	`COMMIT;`
`116`	`116`	`-- Listen`
`117`	`117`	`listen a;`
`118`		`-ERROR: cannotbe executed during recovery`
	`118`	`+ERROR: cannotexecute LISTEN during recovery`
`119`	`119`	`notify a;`
`120`		`-ERROR: cannotbe executed during recovery`
	`120`	`+ERROR: cannotexecute NOTIFY during recovery`
`121`	`121`	`unlisten a;`
`122`		`-ERROR: cannotbe executed during recovery`
	`122`	`+ERROR: cannotexecute UNLISTEN during recovery`
`123`	`123`	`unlisten *;`
`124`		`-ERROR: cannotbe executed during recovery`
	`124`	`+ERROR: cannotexecute UNLISTEN during recovery`
`125`	`125`	`-- disallowed commands`
`126`	`126`	`ANALYZE hs1;`
`127`		`-ERROR: cannotbe executed during recovery`
	`127`	`+ERROR: cannotexecute VACUUM during recovery`
`128`	`128`	`VACUUM hs2;`
`129`		`-ERROR: cannotbe executed during recovery`
	`129`	`+ERROR: cannotexecute VACUUM during recovery`
`130`	`130`	`CLUSTER hs2 using hs1_pkey;`
`131`		`-ERROR: cannotbe executed during recovery`
	`131`	`+ERROR: cannotexecute CLUSTER during recovery`
`132`	`132`	`REINDEX TABLE hs2;`
`133`		`-ERROR: cannotbe executed during recovery`
	`133`	`+ERROR: cannotexecute REINDEX during recovery`
`134`	`134`	`REVOKE SELECT ON hs1 FROM PUBLIC;`
`135`		`-ERROR:transaction isread-only`
	`135`	`+ERROR:cannot execute REVOKE in aread-only transaction`
`136`	`136`	`GRANT SELECT ON hs1 TO PUBLIC;`
`137`		`-ERROR:transaction isread-only`
	`137`	`+ERROR:cannot execute GRANT in aread-only transaction`

`‎src/test/regress/expected/hs_standby_functions.out`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`--`
`6`	`6`	`-- should fail`
`7`	`7`	`select txid_current();`
`8`		`-ERROR: cannotbe executed during recovery`
	`8`	`+ERROR: cannotexecute txid_current() during recovery`
`9`	`9`	`select length(txid_current_snapshot()::text) >= 4;`
`10`	`10`	`?column?`
`11`	`11`	`----------`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit3a0939e

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/hs_standby_disallowed.out`

`‎src/test/regress/expected/hs_standby_functions.out`

0 commit comments