Commit94f610b

committed

Forbid setval() during recovery. This prevents the PANIC reported by

Erik Rijkers. Patch by Andres Freund.

1 parent2f6b456 commit94f610bCopy full SHA for 94f610b

File tree

-1

lines changed

-1

lines changed

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/commands/sequence.c,v 1.166 2010/02/14 18:42:14 rhaas Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/commands/sequence.c,v 1.167 2010/02/19 06:29:19 heikki Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -736,6 +736,9 @@ do_setval(Oid relid, int64 next, bool iscalled)`
`736`	`736`	`Bufferbuf;`
`737`	`737`	`Form_pg_sequenceseq;`
`738`	`738`
	`739`	`+/* setval() writes to database and must be prevented during recovery */`
	`740`	`+PreventCommandDuringRecovery();`
	`741`	`+`
`739`	`742`	`/* open and AccessShareLock sequence */`
`740`	`743`	`init_sequence(relid,&elm,&seqrel);`
`741`	`744`

Comments

(0)