Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
prevent_update_if_locked() FUNCTION plpgsql false trigger INVOKER
set_cluster(json_object json) FUNCTION plpgsql false json INVOKER
check_select_access_by_emails(select_access_by text[]) FUNCTION plpgsql false boolean INVOKER
set_wzp_tree(parent_id integer, json_object json) FUNCTION plpgsql false json INVOKER
set_position(parent_id integer, json_object json) FUNCTION plpgsql false json INVOKER
get_column_permissions(p_table_name text) FUNCTION plpgsql false json INVOKER
remove_rls_policy_and_trigger(table_name text, policy_name text, column_name text DEFAULT NULL::text) FUNCTION plpgsql false json DEFINER
set_plot(parent_id integer, json_object json) FUNCTION plpgsql false json INVOKER
set_plot_location(parent_id integer, json_object json, parent_geometry geometry) FUNCTION plpgsql false json INVOKER
lock_row(cluster_id integer) FUNCTION plpgsql false void INVOKER
apply_rls_policy_and_trigger(table_name text, policy_name text, role_name text, using_expr text, with_check_expr text DEFAULT NULL::text, restricted_column text DEFAULT NULL::text) FUNCTION plpgsql false void INVOKER
check_update_permission(table_name text, column_name text) FUNCTION plpgsql false boolean INVOKER
set_edges(parent_id integer, json_object json, plot_location_id integer) FUNCTION plpgsql false json INVOKER
unlock_row(cluster_id integer) FUNCTION plpgsql false void INVOKER
set_sapling_1m(parent_id integer, json_object json, plot_location_id integer) FUNCTION plpgsql false json INVOKER
set_deadwood(parent_id integer, json_object json, plot_location_id integer) FUNCTION plpgsql false json INVOKER
set_sapling_2m(parent_id integer, json_object json, plot_location_id integer) FUNCTION plpgsql false json INVOKER
apply_rls_policy(table_name text, policy_name text, role_name text, column_name text DEFAULT NULL::text) FUNCTION plpgsql false json DEFINER
update_table() FUNCTION plpgsql false trigger INVOKER
has_column_privilege(user_name text, table_name text, column_name text) FUNCTION plpgsql false boolean INVOKER