Forbid to partition tables with children.

arssher · arssher · commit debe43dba40c · 2019-03-04T18:16:40.000+03:00
Since pathman doesn't check for children existence anyway and duplicates
them. This doesn't explain 'attempted to update invisible tuple' in PGPRO-2507
though, but let's leave this for another time.
diff --git a/init.sql b/init.sql
@@ -455,6 +455,10 @@ BEGIN
 		RAISE EXCEPTION 'table "%" has already been partitioned', parent_relid;
 	END IF;
 
+	IF EXISTS (SELECT 1 FROM pg_inherits WHERE inhparent = parent_relid) THEN
+		RAISE EXCEPTION 'can''t partition table "%" with existing children', parent_relid;
+	END IF;
+
 	/* Check if there are foreign keys that reference the relation */
 	FOR constr_name IN (SELECT conname FROM pg_catalog.pg_constraint
 					WHERE confrelid = parent_relid::REGCLASS::OID)
