CMDBuild Forum

how to delete a domain?

Old Versions
#1

Version 2.3.0, PostgreSQL, Tomcat6, CentOS

I've made a mistake - wrong cardinality for a domain

Created two cards and deleted over GUI

SELECT   *  FROM public."Map_NtwkSRV_Host";

""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"N";"skarandin";"2015-03-06 11:28:51.991247";"";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"N";"skarandin";"2015-03-06 11:29:00.385055";"";487
""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"U";"skarandin";"2015-03-06 10:31:45.894206";"2015-03-06 11:28:51.991247";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"U";"skarandin";"2015-03-06 11:26:37.840774";"2015-03-06 11:29:00.385055";487

SELECT   *  FROM public."Map_NtwkSRV_Host_history";

""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"U";"skarandin";"2015-03-06 10:31:45.894206";"2015-03-06 11:28:51.991247";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"U";"skarandin";"2015-03-06 11:26:37.840774";"2015-03-06 11:29:00.385055";487

 



 



 

 

#2

You can make “not active” the wrong domain and create another one in the right way.
Otherwise you should go directly in the database, temporarily disable the triggers used by CMDBuild to manage the data history and delete manually with SQL queries the “versioned” cards.
But this is a very dangerous operation (the database may become inconsistent) and is only recommended for advanced users.
CMDBuild Team

 

 



 

 

 

#3
taking care managing database with drop cascade you can clean it at all
 
but, take care...
 
@errecepe 
 
Previously Stepan Karandin wrote:

Version 2.3.0, PostgreSQL, Tomcat6, CentOS

I've made a mistake - wrong cardinality for a domain

Created two cards and deleted over GUI

SELECT   *  FROM public."Map_NtwkSRV_Host";

""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"N";"skarandin";"2015-03-06 11:28:51.991247";"";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"N";"skarandin";"2015-03-06 11:29:00.385055";"";487
""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"U";"skarandin";"2015-03-06 10:31:45.894206";"2015-03-06 11:28:51.991247";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"U";"skarandin";"2015-03-06 11:26:37.840774";"2015-03-06 11:29:00.385055";487

SELECT   *  FROM public."Map_NtwkSRV_Host_history";

""Map_NtwkSRV_Host"";""NetworkingService"";417;""VMX"";161;"U";"skarandin";"2015-03-06 10:31:45.894206";"2015-03-06 11:28:51.991247";419
""Map_NtwkSRV_Host"";""NetworkingService"";484;""VMX"";269;"U";"skarandin";"2015-03-06 11:26:37.840774";"2015-03-06 11:29:00.385055";487