02-01-2013 07:09 AM
02-01-2013 10:56 AM
07-10-2013 01:11 PM
07-10-2013 02:40 PM
pg_dump alfresco -U alfresco -h localhost > ~/alfresco-backup.sql
psql -U postgres -h localhost
drop database alfresco;
create database alfresco;
alter database alfresco owner to alfresco;
\q
psql -d alfresco -U alfresco -h localhost < ~/alfresco-backup.sql
select * from alf_node where type_qname_id in (317);
delete from alf_node_assoc where target_node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_node_aspects where node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_child_assoc where parent_node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_node_properties where node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_node where type_qname_id in (317);
07-11-2013 12:32 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.