Commit02af785

committed

Allow a rule on partitioned table to be renamed.

1 parent6599c9a commit02af785Copy full SHA for 02af785

File tree

+18

-1

lines changed

+18

-1

lines changed

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -900,7 +900,9 @@ RangeVarCallbackForRenameRule(const RangeVar *rv, Oid relid, Oid oldrelid,`
`900`	`900`	`form= (Form_pg_class)GETSTRUCT(tuple);`
`901`	`901`
`902`	`902`	`/* only tables and views can have rules */`
`903`		`-if (form->relkind!=RELKIND_RELATION&&form->relkind!=RELKIND_VIEW)`
	`903`	`+if (form->relkind!=RELKIND_RELATION&&`
	`904`	`+form->relkind!=RELKIND_VIEW&&`
	`905`	`+form->relkind!=RELKIND_PARTITIONED_TABLE)`
`904`	`906`	`ereport(ERROR,`
`905`	`907`	`(errcode(ERRCODE_WRONG_OBJECT_TYPE),`
`906`	`908`	`errmsg("\"%s\" is not a table or view",rv->relname)));`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3216,3 +3216,10 @@ SELECT pg_get_function_arg_default('pg_class'::regclass, 0);`
`3216`	`3216`
`3217`	`3217`	`(1 row)`
`3218`	`3218`
	`3219`	`+-- test rename for a rule defined on a partitioned table`
	`3220`	`+CREATE TABLE parted_table (a int) PARTITION BY LIST (a);`
	`3221`	`+CREATE TABLE parted_table_1 PARTITION OF parted_table FOR VALUES IN (1);`
	`3222`	`+CREATE RULE parted_table_insert AS ON INSERT to parted_table`
	`3223`	`+ DO INSTEAD INSERT INTO parted_table_1 VALUES (NEW.*);`
	`3224`	`+ALTER RULE parted_table_insert ON parted_table RENAME TO parted_table_insert_redirect;`
	`3225`	`+DROP TABLE parted_table;`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1158,3 +1158,11 @@ SELECT pg_get_function_identity_arguments(0);`
`1158`	`1158`	`SELECT pg_get_function_result(0);`
`1159`	`1159`	`SELECT pg_get_function_arg_default(0,0);`
`1160`	`1160`	`SELECT pg_get_function_arg_default('pg_class'::regclass,0);`
	`1161`	`+`
	`1162`	`+-- test rename for a rule defined on a partitioned table`
	`1163`	`+CREATETABLEparted_table (aint) PARTITION BY LIST (a);`
	`1164`	`+CREATETABLEparted_table_1 PARTITION OF parted_table FORVALUESIN (1);`
	`1165`	`+CREATERULEparted_table_insertASON INSERT to parted_table`
	`1166`	`+ DO INSTEADINSERT INTO parted_table_1VALUES (NEW.*);`
	`1167`	`+ALTERRULE parted_table_insertON parted_table RENAME TO parted_table_insert_redirect;`
	`1168`	`+DROPTABLE parted_table;`

Comments

(0)