Project

General

Profile

« Previous | Next » 

Revision 12492

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/util.sql, vegbien.sql: comment about "function option search_path": don't include `mk_set_search_path()` since that is no longer used

View differences:

trunk/schemas/util.sql
1053 1053 
changes of search_path (schema elements are bound at inline time rather than
1054 1054 
runtime) */
1055 1055 
/* function option search_path is needed to limit the effects of
1056 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
1056 
`SET LOCAL search_path` to the current function */
1057 1057 
BEGIN
1058 1058 
	PERFORM util.use_schema($3); -- includes util.%== as default/fallback
1059 1059
trunk/schemas/vegbien.sql
723 723 
changes of search_path (schema elements are bound at inline time rather than
724 724 
runtime) */
725 725 
/* function option search_path is needed to limit the effects of
726 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
726 
`SET LOCAL search_path` to the current function */
727 727 
DECLARE
728 728 
	live_datasource text := rm_version_suffix(datasource);
729 729 
BEGIN
......
761 761 
changes of search_path (schema elements are bound at inline time rather than
762 762 
runtime) */
763 763 
/* function option search_path is needed to limit the effects of
764 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
764 
`SET LOCAL search_path` to the current function */
765 765 
BEGIN
766 766 
	PERFORM util.use_schema(schema_anchor);
767 767 
	UPDATE source SET shortname = new WHERE shortname = old;
......
792 792 
changes of search_path (schema elements are bound at inline time rather than
793 793 
runtime) */
794 794 
/* function option search_path is needed to limit the effects of
795 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
795 
`SET LOCAL search_path` to the current function */
796 796 
BEGIN
797 797 
	PERFORM util.use_schema(schema_anchor);
798 798 
	DELETE FROM source WHERE shortname = datasource;
......
833 833 
changes of search_path (schema elements are bound at inline time rather than
834 834 
runtime) */
835 835 
/* function option search_path is needed to limit the effects of
836 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
836 
`SET LOCAL search_path` to the current function */
837 837 
BEGIN
838 838 
	PERFORM util.use_schema(schema_anchor);
839 839 
	PERFORM datasource_rename(datasource, datasource||'.new');
......
1377 1377 
changes of search_path (schema elements are bound at inline time rather than
1378 1378 
runtime) */
1379 1379 
/* function option search_path is needed to limit the effects of
1380 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
1380 
`SET LOCAL search_path` to the current function */
1381 1381 
BEGIN
1382 1382 
	PERFORM util.use_schema(schema_anchor);
1383 1383 
	PERFORM public_schema_publish(util.schema_esc(schema_anchor));
......
1414 1414 
changes of search_path (schema elements are bound at inline time rather than
1415 1415 
runtime) */
1416 1416 
/* function option search_path is needed to limit the effects of
1417 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
1417 
`SET LOCAL search_path` to the current function */
1418 1418 
BEGIN
1419 1419 
	PERFORM util.use_schema(schema_anchor);
1420 1420 
	PERFORM util.schema_bundle_rm(util.schema_esc(schema_anchor));
......
1462 1462 
changes of search_path (schema elements are bound at inline time rather than
1463 1463 
runtime) */
1464 1464 
/* function option search_path is needed to limit the effects of
1465 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
1465 
`SET LOCAL search_path` to the current function */
1466 1466 
DECLARE
1467 1467 
	source_id_ integer;
1468 1468 
	shortname_ text = shortname;
......
2060 2060 
changes of search_path (schema elements are bound at inline time rather than
2061 2061 
runtime) */
2062 2062 
/* function option search_path is needed to limit the effects of
2063 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2063 
`SET LOCAL search_path` to the current function */
2064 2064 
DECLARE
2065 2065 
	type_table text = util.qual_name(util.schema(schema_anchor),
2066 2066 
		'~type.'||util.name(in_view)); -- sort at end
......
2111 2111 
changes of search_path (schema elements are bound at inline time rather than
2112 2112 
runtime) */
2113 2113 
/* function option search_path is needed to limit the effects of
2114 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2114 
`SET LOCAL search_path` to the current function */
2115 2115 
BEGIN
2116 2116 
	PERFORM util.use_schema(schema_anchor);
2117 2117
......
2132 2132 
changes of search_path (schema elements are bound at inline time rather than
2133 2133 
runtime) */
2134 2134 
/* function option search_path is needed to limit the effects of
2135 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2135 
`SET LOCAL search_path` to the current function */
2136 2136 
DECLARE
2137 2137 
	errors_ct integer = 0;
2138 2138 
	in_view regclass;
......
2209 2209 
changes of search_path (schema elements are bound at inline time rather than
2210 2210 
runtime) */
2211 2211 
/* function option search_path is needed to limit the effects of
2212 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2212 
`SET LOCAL search_path` to the current function */
2213 2213 
DECLARE
2214 2214 
	out_table text = util.qual_name(datasource_schema,
2215 2215 
		'_out_'||util.name(out_view));
......
2251 2251 
changes of search_path (schema elements are bound at inline time rather than
2252 2252 
runtime) */
2253 2253 
/* function option search_path is needed to limit the effects of
2254 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2254 
`SET LOCAL search_path` to the current function */
2255 2255 
BEGIN
2256 2256 
	PERFORM util.use_schema(schema_anchor);
2257 2257
......
2288 2288 
changes of search_path (schema elements are bound at inline time rather than
2289 2289 
runtime) */
2290 2290 
/* function option search_path is needed to limit the effects of
2291 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2291 
`SET LOCAL search_path` to the current function */
2292 2292 
BEGIN
2293 2293 
	PERFORM util.use_schema(schema_anchor);
2294 2294
......
2358 2358 
changes of search_path (schema elements are bound at inline time rather than
2359 2359 
runtime) */
2360 2360 
/* function option search_path is needed to limit the effects of
2361 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2361 
`SET LOCAL search_path` to the current function */
2362 2362 
BEGIN
2363 2363 
	PERFORM util.use_schema(schema_anchor);
2364 2364
......
2398 2398 
changes of search_path (schema elements are bound at inline time rather than
2399 2399 
runtime) */
2400 2400 
/* function option search_path is needed to limit the effects of
2401 
`SET LOCAL search_path` (mk_set_search_path()) to the current function */
2401 
`SET LOCAL search_path` to the current function */
2402 2402 
BEGIN
2403 2403 
	PERFORM util.use_schema(schema_anchor);
2404 2404

Also available in: Unified diff