gw_fct_admin_manage_ct - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to admin constraints of given schema

Input example

SELECT gw_fct_admin_manage_ct($${"client":{"lang":"ES"}, 
"data":{"action":"DROP"}}$$);

SELECT gw_fct_admin_manage_ct($${"client":{"lang":"ES"}, 
"data":{"action":"ADD"}}$$);

SELECT gw_fct_admin_manage_ct($${"client":{"lang":"ES"}, 
"data":{"action":"DISABLE TOPO-TRIGGERS"}}$$);

SELECT gw_fct_admin_manage_ct($${"client":{"lang":"ES"}, 
"data":{"action":"ENABLE TOPO-TRIGGERS"}}$$)

Output example

{
  "constraints dropped":"400","notnull dropped":"198"
}