Oct 8, 2024 · Oct 8, 2024
diff --git a/range.sql b/range.sql
 EXECUTE pg_catalog.format('SELECT count(*), max(%s) FROM %s', expression, parent_relid)
 INTO rows_count, max_value;

 IF rows_count = 0 THEN
 RAISE EXCEPTION 'cannot determine partitions count for empty table';
 END IF;

 p_count := 0;
 WHILE cur_value <= max_value
 LOOP
 EXECUTE pg_catalog.format('SELECT count(*), max(%s) FROM %s', expression, parent_relid)
 INTO rows_count, max_value;

 IF rows_count = 0 THEN
 RAISE EXCEPTION 'cannot determine partitions count for empty table';
 END IF;

 IF max_value IS NULL THEN
 RAISE EXCEPTION 'expression "%" can return NULL values', expression;
 END IF;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -79,10 +79,6 @@ BEGIN
		EXECUTE pg_catalog.format('SELECT count(*), max(%s) FROM %s', expression, parent_relid)
		INTO rows_count, max_value;

		IF rows_count = 0 THEN
		RAISE EXCEPTION 'cannot determine partitions count for empty table';
		END IF;

		p_count := 0;
		WHILE cur_value <= max_value
		LOOP
Expand DownExpand Up		@@ -172,10 +168,6 @@ BEGIN
		EXECUTE pg_catalog.format('SELECT count(*), max(%s) FROM %s', expression, parent_relid)
		INTO rows_count, max_value;

		IF rows_count = 0 THEN
		RAISE EXCEPTION 'cannot determine partitions count for empty table';
		END IF;

		IF max_value IS NULL THEN
		RAISE EXCEPTION 'expression "%" can return NULL values', expression;
		END IF;
Expand Down