Commitfdf0041

authored and

committed

'return next'-related bugfixes

1 parent65602a3 commitfdf0041Copy full SHA for fdf0041

File tree

-1

lines changed

-1

lines changed

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -380,12 +380,16 @@ CREATE FUNCTION dump_statistic(schema_name text, table_name text) RETURNS SETOF`
`380`	`380`	`DECLARE`
`381`	`381`	`qual_relnametext;`
`382`	`382`	`relidoid;`
	`383`	`+itext;`
`383`	`384`
`384`	`385`	`BEGIN`
`385`	`386`	`qual_relname := quote_ident(schema_name)\|\|`
`386`	`387`	`'.'\|\| quote_ident(table_name);`
`387`	`388`
`388`		`-return next dump_statistic(qual_relname::regclass);`
	`389`	`+for iinselect dump_statistic(qual_relname::regclass) loop`
	`390`	`+return next i;`
	`391`	`+end loop;`
	`392`	`+`
`389`	`393`	`return;`
`390`	`394`
`391`	`395`	`EXCEPTION`
`@@ -416,6 +420,8 @@ CREATE FUNCTION dump_statistic(schema_name text) RETURNS SETOF TEXT AS $$`
`416`	`420`	`return next i;`
`417`	`421`	`end loop;`
`418`	`422`	`end loop;`
	`423`	`+`
	`424`	`+return;`
`419`	`425`	`END;`
`420`	`426`	`$$ LANGUAGE plpgsql;`
`421`	`427`
`@@ -436,5 +442,7 @@ CREATE FUNCTION dump_statistic() RETURNS SETOF TEXT AS $$`
`436`	`442`	`return next i;`
`437`	`443`	`end loop;`
`438`	`444`	`end loop;`
	`445`	`+`
	`446`	`+return;`
`439`	`447`	`END;`
`440`	`448`	`$$ LANGUAGE plpgsql;`

Comments

(0)