Commit5c1b004

committed

Fixed but in _enableTriggersIfNecessary introduced by previous patches by me

which caused segfault in a data-only retore with BLOBs

1 parentfd5bac6 commit5c1b004Copy full SHA for 5c1b004

File tree

-1

lines changed

-1

lines changed

Lines changed: 8 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -471,10 +471,17 @@ static void _enableTriggersIfNecessary(ArchiveHandle AH, TocEntry te, RestoreO`
`471`	`471`	`* command when one is available.`
`472`	`472`	`*/`
`473`	`473`	`ahprintf(AH,"-- Enable triggers\n");`
`474`		`-ahprintf(AH,"UPDATE pg_class SET reltriggers = "`
	`474`	`+if (te&&te->name&&strlen(te->name)>0)`
	`475`	`+{`
	`476`	`+ahprintf(AH,"UPDATE pg_class SET reltriggers = "`
`475`	`477`	`"(SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) "`
`476`	`478`	`"WHERE relname = '%s';\n\n",`
`477`	`479`	`te->name);`
	`480`	`+}else {`
	`481`	`+ahprintf(AH,"UPDATE \"pg_class\" SET \"reltriggers\" = "`
	`482`	`+"(SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) "`
	`483`	`+"WHERE \"relname\" !~ '^pg_';\n\n");`
	`484`	`+}`
`478`	`485`
`479`	`486`	`/*`
`480`	`487`	`* Restore the user connection from the start of this procedure`

Comments

(0)