Commit581a695

committed

fix migration script (broken DROP TRIGGER, after-update-instruction)

1 parente31e4b5 commit581a695Copy full SHA for 581a695

File tree

+12

-1

lines changed

+12

-1

lines changed

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -26,7 +26,7 @@ DROP FUNCTION @extschema@.split_range_partition(REGCLASS, ANYELEMENT, TEXT, OUT`
`26`	`26`	`DROPFUNCTION @extschema@.invalidate_relcache(OID);`
`27`	`27`
`28`	`28`	`/* drop trigger and its function (PATHMAN_CONFIG_PARAMS)*/`
`29`		`-DROPTRIGGER pathman_config_params_trigger;`
	`29`	`+DROPTRIGGER pathman_config_params_triggerON @extschema@.pathman_config_params;`
`30`	`30`	`DROPFUNCTION @extschema@.pathman_config_params_trigger_func();`
`31`	`31`
`32`	`32`
`@@ -1291,3 +1291,14 @@ LANGUAGE C STRICT;`
`1291`	`1291`	`* ----------------------------------------------------------------------*/`
`1292`	`1292`	`ALTERTABLE @extschema@.pathman_config_params ADD COLUMN spawn_using_bgwBOOLEANNOT NULL DEFAULT FALSE;`
`1293`	`1293`	`ALTERTABLE @extschema@.pathman_config_params ADDCHECK (@extschema@.validate_part_callback(init_callback));`
	`1294`	`+`
	`1295`	`+`
	`1296`	`+/* ------------------------------------------------------------------------`
	`1297`	`+ * Final words of wisdom`
	`1298`	`+ * ----------------------------------------------------------------------*/`
	`1299`	`+DO language plpgsql`
	`1300`	`+$$`
	`1301`	`+BEGIN`
	`1302`	`+RAISE WARNING'Don''t forget to execute "SET pg_pathman.enable = t" to activate pg_pathman';`
	`1303`	`+END`
	`1304`	`+$$;`

Comments

(0)