Skip to content

gw_fct_admin_manage_ct

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

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"
}
Clone this wiki locally