gis.road_graph

Parameters

Name	Type	Mode
_toggle	boolean	IN

Definition

DECLARE
sql_text text;
fkey_item record;
BEGIN

-- We cannot use SET session_replication_role to (dis-)allow the triggers
    -- since only granted roles can set it.
    -- Drop the foreign key constraints if they exist
    ALTER TABLE road_graph.edges DROP CONSTRAINT IF EXISTS "edges_end_node_fkey";
    ALTER TABLE road_graph.edges DROP CONSTRAINT IF EXISTS "edges_road_code_fkey";
    ALTER TABLE road_graph.edges DROP CONSTRAINT IF EXISTS "edges_start_node_fkey";
    ALTER TABLE road_graph.markers DROP CONSTRAINT IF EXISTS "markers_road_code_fkey";
    ALTER TABLE road_graph.roads DROP CONSTRAINT IF EXISTS "roads_road_scale_fkey";

-- add the foreign key constraint if needed
    IF _toggle THEN
        ALTER TABLE road_graph.edges ADD CONSTRAINT "edges_end_node_fkey"
            FOREIGN KEY (end_node) REFERENCES road_graph.nodes(id)
            ON UPDATE CASCADE ON DELETE RESTRICT;
        ALTER TABLE road_graph.edges ADD CONSTRAINT "edges_road_code_fkey"
            FOREIGN KEY (road_code) REFERENCES road_graph.roads(road_code)
            ON UPDATE CASCADE ON DELETE RESTRICT;
        ALTER TABLE road_graph.edges ADD CONSTRAINT "edges_start_node_fkey"
            FOREIGN KEY (start_node) REFERENCES road_graph.nodes(id)
            ON UPDATE CASCADE ON DELETE RESTRICT;
        ALTER TABLE road_graph.markers ADD CONSTRAINT "markers_road_code_fkey"
            FOREIGN KEY (road_code) REFERENCES road_graph.roads(road_code)
            ON UPDATE CASCADE ON DELETE RESTRICT;
        ALTER TABLE road_graph.roads ADD CONSTRAINT "roads_road_scale_fkey" FOREIGN KEY (road_class)
            REFERENCES road_graph.glossary_road_class(code)
            ON UPDATE CASCADE ON DELETE RESTRICT;
    END IF;

RETURN True;
END;

toggle_foreign_key_constraints(_toggle boolean DEFAULT true)

Description

Parameters

Definition