 /*
 delete from BRIDGE_INSTALLATION
 */
-CREATE OR REPLACE FUNCTION geodb_pkg.delete_bridge_inst(
+CREATE OR REPLACE FUNCTION geodb_pkg.delete_bridge_installation(
   brdi_id INTEGER, 
   schema_name VARCHAR DEFAULT 'public'
   ) RETURNS SETOF VOID AS

                    schema_name, schema_name, b_id, b_id);

  -- delete referenced building installation(s)
  EXECUTE format('SELECT geodb_pkg.delete_building_inst(id, %L) FROM %I.building_installation WHERE building_id = %L', 
                    schema_name, schema_name, b_id);

  -- delete referenced thematic surfaces

*   delete_tunnel(tun_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_tunnel_furniture(tunf_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_tunnel_hollow_space(tunhs_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_tunnel_installation(tuni_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_tunnel_opening(tuno_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_tunnel_them_srf(tuntd_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
*   delete_waterbnd_surface(wbs_id INTEGER, schema_name VARCHAR DEFAULT 'public') RETURNS SETOF VOID
