Commitb2c4f8e

committed

migration script fix

1 parentbc4871a commitb2c4f8eCopy full SHA for b2c4f8e

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -16,18 +16,23 @@ ADD CHECK (@extschema@.validate_interval_value(partrel,`
`16`	`16`	`parttype,`
`17`	`17`	`range_interval));`
`18`	`18`
	`19`	`+/*`
	`20`	`+ * Drop check constraint to be able to update column type. We recreate it`
	`21`	`+ * later and it will be slightly different`
	`22`	`+*/`
	`23`	`+DROPFUNCTION @extschema@.validate_part_callback(REGPROC, BOOL) CASCADE;`
	`24`	`+`
`19`	`25`	`/* Change type for init_callback attribute*/`
`20`	`26`	`ALTERTABLE @extschema@.pathman_config_params`
`21`	`27`	`ALTER COLUMN init_callback TYPETEXT,`
	`28`	`+ALTER COLUMN init_callback DROPNOT NULL,`
`22`	`29`	`ALTER COLUMN init_callbackSET DEFAULTNULL;`
`23`	`30`
`24`	`31`	`/* Set init_callback to NULL where it used to be 0*/`
`25`	`32`	`UPDATE @extschema@.pathman_config_params`
`26`	`33`	`SET init_callback=NULL`
`27`	`34`	`WHERE init_callback='-';`
`28`	`35`
`29`		`-DROPFUNCTION @extschema@.validate_part_callback(REGPROC, BOOL);`
`30`		`-`
`31`	`36`	`CREATEOR REPLACE FUNCTION @extschema@.validate_part_callback(`
`32`	`37`	`callbackREGPROCEDURE,`
`33`	`38`	`raise_errorBOOL DEFAULT TRUE)`

Comments

(0)