Revision 12503
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 745 | 745 |
COMMENT ON FUNCTION datasource_publish(datasource text, schema_anchor anyelement) IS ' |
| 746 | 746 |
secure against renamings of the public schema. |
| 747 | 747 |
|
| 748 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 748 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 749 | 749 |
'; |
| 750 | 750 |
|
| 751 | 751 |
|
| ... | ... | |
| 776 | 776 |
COMMENT ON FUNCTION datasource_rename(old text, new text, schema_anchor anyelement) IS ' |
| 777 | 777 |
secure against renamings of the public schema. |
| 778 | 778 |
|
| 779 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 779 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 780 | 780 |
'; |
| 781 | 781 |
|
| 782 | 782 |
|
| ... | ... | |
| 807 | 807 |
COMMENT ON FUNCTION datasource_rm(datasource text, schema_anchor anyelement) IS ' |
| 808 | 808 |
secure against renamings of the public schema. |
| 809 | 809 |
|
| 810 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 810 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 811 | 811 |
|
| 812 | 812 |
runtime: |
| 813 | 813 |
ACAD: 30 s : 27738 ms/ 45,503 rows = 0.61 ms/row |
| ... | ... | |
| 848 | 848 |
COMMENT ON FUNCTION datasource_unpublish(datasource text, schema_anchor anyelement) IS ' |
| 849 | 849 |
secure against renamings of the public schema. |
| 850 | 850 |
|
| 851 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 851 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 852 | 852 |
'; |
| 853 | 853 |
|
| 854 | 854 |
|
| ... | ... | |
| 1398 | 1398 |
|
| 1399 | 1399 |
secure against renamings of the public schema. |
| 1400 | 1400 |
|
| 1401 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 1401 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 1402 | 1402 |
'; |
| 1403 | 1403 |
|
| 1404 | 1404 |
|
| ... | ... | |
| 1435 | 1435 |
|
| 1436 | 1436 |
secure against renamings of the public schema. |
| 1437 | 1437 |
|
| 1438 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 1438 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 1439 | 1439 |
'; |
| 1440 | 1440 |
|
| 1441 | 1441 |
|
| ... | ... | |
| 2095 | 2095 |
|
| 2096 | 2096 |
idempotent, but repeats action each time |
| 2097 | 2097 |
|
| 2098 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2098 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2099 | 2099 |
'; |
| 2100 | 2100 |
|
| 2101 | 2101 |
|
| ... | ... | |
| 2272 | 2272 |
|
| 2273 | 2273 |
idempotent, but repeats action each time |
| 2274 | 2274 |
|
| 2275 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2275 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2276 | 2276 |
'; |
| 2277 | 2277 |
|
| 2278 | 2278 |
|
| ... | ... | |
| 2312 | 2312 |
|
| 2313 | 2313 |
idempotent |
| 2314 | 2314 |
|
| 2315 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2315 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2316 | 2316 |
'; |
| 2317 | 2317 |
|
| 2318 | 2318 |
|
| ... | ... | |
| 2342 | 2342 |
|
| 2343 | 2343 |
idempotent |
| 2344 | 2344 |
|
| 2345 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2345 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2346 | 2346 |
'; |
| 2347 | 2347 |
|
| 2348 | 2348 |
|
| ... | ... | |
| 2382 | 2382 |
|
| 2383 | 2383 |
idempotent |
| 2384 | 2384 |
|
| 2385 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2385 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2386 | 2386 |
'; |
| 2387 | 2387 |
|
| 2388 | 2388 |
|
| ... | ... | |
| 2421 | 2421 |
$_$; |
| 2422 | 2422 |
|
| 2423 | 2423 |
|
| 2424 |
-- |
|
| 2425 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2426 |
-- |
|
| 2427 |
|
|
| 2428 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2429 |
"totalRecords" bigint |
|
| 2430 |
); |
|
| 2431 |
|
|
| 2432 |
|
|
| 2433 |
-- |
|
| 2434 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2435 |
-- |
|
| 2436 |
|
|
| 2437 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2438 |
traits bigint |
|
| 2439 |
); |
|
| 2440 |
|
|
| 2441 |
|
|
| 2442 |
-- |
|
| 2443 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2444 |
-- |
|
| 2445 |
|
|
| 2446 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2447 |
trait text |
|
| 2448 |
); |
|
| 2449 |
|
|
| 2450 |
|
|
| 2451 |
-- |
|
| 2452 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2453 |
-- |
|
| 2454 |
|
|
| 2455 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2456 |
taxa bigint |
|
| 2457 |
); |
|
| 2458 |
|
|
| 2459 |
|
|
| 2460 |
-- |
|
| 2461 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2462 |
-- |
|
| 2463 |
|
|
| 2464 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2465 |
taxonwithauthor text |
|
| 2466 |
); |
|
| 2467 |
|
|
| 2468 |
|
|
| 2469 |
-- |
|
| 2470 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2471 |
-- |
|
| 2472 |
|
|
| 2473 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2474 |
trait text, |
|
| 2475 |
value text, |
|
| 2476 |
units text |
|
| 2477 |
); |
|
| 2478 |
|
|
| 2479 |
|
|
| 2480 |
-- |
|
| 2481 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2482 |
-- |
|
| 2483 |
|
|
| 2484 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2485 |
taxonwithauthor text, |
|
| 2486 |
trait text, |
|
| 2487 |
value text |
|
| 2488 |
); |
|
| 2489 |
|
|
| 2490 |
|
|
| 2491 | 2424 |
SET search_path = public, pg_catalog; |
| 2492 | 2425 |
|
| 2493 | 2426 |
-- |
| ... | ... | |
| 6429 | 6362 |
); |
| 6430 | 6363 |
|
| 6431 | 6364 |
|
| 6365 |
-- |
|
| 6366 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6367 |
-- |
|
| 6368 |
|
|
| 6369 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 6370 |
"totalRecords" bigint |
|
| 6371 |
); |
|
| 6372 |
|
|
| 6373 |
|
|
| 6374 |
-- |
|
| 6375 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6376 |
-- |
|
| 6377 |
|
|
| 6378 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 6379 |
traits bigint |
|
| 6380 |
); |
|
| 6381 |
|
|
| 6382 |
|
|
| 6383 |
-- |
|
| 6384 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6385 |
-- |
|
| 6386 |
|
|
| 6387 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 6388 |
trait text |
|
| 6389 |
); |
|
| 6390 |
|
|
| 6391 |
|
|
| 6392 |
-- |
|
| 6393 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6394 |
-- |
|
| 6395 |
|
|
| 6396 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 6397 |
taxa bigint |
|
| 6398 |
); |
|
| 6399 |
|
|
| 6400 |
|
|
| 6401 |
-- |
|
| 6402 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6403 |
-- |
|
| 6404 |
|
|
| 6405 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 6406 |
taxonwithauthor text |
|
| 6407 |
); |
|
| 6408 |
|
|
| 6409 |
|
|
| 6410 |
-- |
|
| 6411 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6412 |
-- |
|
| 6413 |
|
|
| 6414 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 6415 |
trait text, |
|
| 6416 |
value text, |
|
| 6417 |
units text |
|
| 6418 |
); |
|
| 6419 |
|
|
| 6420 |
|
|
| 6421 |
-- |
|
| 6422 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6423 |
-- |
|
| 6424 |
|
|
| 6425 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 6426 |
taxonwithauthor text, |
|
| 6427 |
trait text, |
|
| 6428 |
value text |
|
| 6429 |
); |
|
| 6430 |
|
|
| 6431 |
|
|
| 6432 | 6432 |
SET search_path = public, pg_catalog; |
| 6433 | 6433 |
|
| 6434 | 6434 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: schema_anchor: clarified that this identifies this function's schema (for use in locating helper functions), but is not necessarily the schema operated on, as the comment implied