NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitd807338

committed

remove exception blocks in PL/pgSQL functions

1 parente82348b commitd807338Copy full SHA for d807338

File tree

2 files changed

-33

lines changed

2 files changed

-33

lines changed

`‎hash.sql`

Lines changed: 0 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -83,9 +83,6 @@ BEGIN`
`83`	`83`	`END IF;`
`84`	`84`
`85`	`85`	`RETURN partitions_count;`
`86`		`-`
`87`		`-EXCEPTION WHEN others THEN`
`88`		`-RAISE EXCEPTION'%', SQLERRM;`
`89`	`86`	`END`
`90`	`87`	`$$ LANGUAGE plpgsql`
`91`	`88`	`SET client_min_messages= WARNING;`

`‎range.sql`

Lines changed: 0 additions & 30 deletions

Original file line number	Diff line number	Diff line change
`@@ -174,9 +174,6 @@ BEGIN`
`174`	`174`	`END IF;`
`175`	`175`
`176`	`176`	`RETURN p_count;`
`177`		`-`
`178`		`-EXCEPTION WHEN others THEN`
`179`		`-RAISE EXCEPTION'%', SQLERRM;`
`180`	`177`	`END`
`181`	`178`	`$$ LANGUAGE plpgsql;`
`182`	`179`
`@@ -280,9 +277,6 @@ BEGIN`
`280`	`277`	`END IF;`
`281`	`278`
`282`	`279`	`RETURN p_count;`
`283`		`-`
`284`		`-EXCEPTION WHEN others THEN`
`285`		`-RAISE EXCEPTION'%', SQLERRM;`
`286`	`280`	`END`
`287`	`281`	`$$ LANGUAGE plpgsql;`
`288`	`282`
`@@ -356,9 +350,6 @@ BEGIN`
`356`	`350`	`END IF;`
`357`	`351`
`358`	`352`	`RETURN part_count;/* number of created partitions*/`
`359`		`-`
`360`		`-EXCEPTION WHEN others THEN`
`361`		`-RAISE EXCEPTION'%', SQLERRM;`
`362`	`353`	`END`
`363`	`354`	`$$ LANGUAGE plpgsql;`
`364`	`355`
`@@ -429,9 +420,6 @@ BEGIN`
`429`	`420`	`END IF;`
`430`	`421`
`431`	`422`	`RETURN part_count;/* number of created partitions*/`
`432`		`-`
`433`		`-EXCEPTION WHEN others THEN`
`434`		`-RAISE EXCEPTION'%', SQLERRM;`
`435`	`423`	`END`
`436`	`424`	`$$ LANGUAGE plpgsql;`
`437`	`425`
`@@ -772,9 +760,6 @@ BEGIN`
`772`	`760`	`/* Invalidate cache*/`
`773`	`761`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`774`	`762`	`RETURN v_part_name;`
`775`		`-`
`776`		`-EXCEPTION WHEN others THEN`
`777`		`-RAISE EXCEPTION'%', SQLERRM;`
`778`	`763`	`END`
`779`	`764`	`$$`
`780`	`765`	`LANGUAGE plpgsql;`
`@@ -870,9 +855,6 @@ BEGIN`
`870`	`855`	`/* Invalidate cache*/`
`871`	`856`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`872`	`857`	`RETURN v_part_name;`
`873`		`-`
`874`		`-EXCEPTION WHEN others THEN`
`875`		`-RAISE EXCEPTION'%', SQLERRM;`
`876`	`858`	`END`
`877`	`859`	`$$`
`878`	`860`	`LANGUAGE plpgsql;`
`@@ -962,9 +944,6 @@ BEGIN`
`962`	`944`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`963`	`945`
`964`	`946`	`RETURN v_part_name;`
`965`		`-`
`966`		`-EXCEPTION WHEN others THEN`
`967`		`-RAISE EXCEPTION'%', SQLERRM;`
`968`	`947`	`END`
`969`	`948`	`$$`
`970`	`949`	`LANGUAGE plpgsql;`
`@@ -995,9 +974,6 @@ BEGIN`
`995`	`974`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`996`	`975`
`997`	`976`	`RETURN part_name;`
`998`		`-`
`999`		`-EXCEPTION WHEN others THEN`
`1000`		`-RAISE EXCEPTION'%', SQLERRM;`
`1001`	`977`	`END`
`1002`	`978`	`$$`
`1003`	`979`	`LANGUAGE plpgsql;`
`@@ -1059,9 +1035,6 @@ BEGIN`
`1059`	`1035`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`1060`	`1036`
`1061`	`1037`	`RETURN p_partition;`
`1062`		`-`
`1063`		`-EXCEPTION WHEN others THEN`
`1064`		`-RAISE EXCEPTION'%', SQLERRM;`
`1065`	`1038`	`END`
`1066`	`1039`	`$$`
`1067`	`1040`	`LANGUAGE plpgsql;`
`@@ -1106,9 +1079,6 @@ BEGIN`
`1106`	`1079`	`PERFORM @extschema@.on_update_partitions(parent_relid);`
`1107`	`1080`
`1108`	`1081`	`RETURN p_partition;`
`1109`		`-`
`1110`		`-EXCEPTION WHEN others THEN`
`1111`		`-RAISE EXCEPTION'%', SQLERRM;`
`1112`	`1082`	`END`
`1113`	`1083`	`$$`
`1114`	`1084`	`LANGUAGE plpgsql;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitd807338

File tree

2 files changed

2 files changed

`‎hash.sql`

`‎range.sql`

0 commit comments