Hi, But if I directly update the quick table and set the "c_status" column to 0, it should produce the same result, isn't it? Or there is something else done by the sogo-tool?
Thanks Renaud Le Mercredi 25 Mai 2011 12:01 EDT, Ludovic Marcotte <[email protected]> a écrit: > On 25/05/11 11:53, Renaud Levesque wrote: > > Is there a way to restore deleted objects, particularly deleted tasks, by > > updating tables directly in the database (postgresql)? > > > > I tried to change the column "c_deleted" of table "sogologinxyz", setting > > it to null, but it didn't had any effect. I also tried to change the > > "c_status" column of table "sogologinxyz_quick", setting it to 1, but again > > it didn't change anything. > That won't work "as-is" since the quick tables also need to be updated. > > You might be able to set it to 1, use sogo-tool to backup the resource, > set it to 0, use sogo-tool to restore the data. > > Regards, > > -- > Ludovic Marcotte > [email protected] :: +1.514.755.3630 :: www.inverse.ca > Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence > (www.packetfence.org) > > -- > [email protected] > https://inverse.ca/sogo/lists -- Renaud Levesque CPTAQ Commission de protection du territoire agricole du Québec Direction des services à la gestion 200 Chemin Ste-Foy, 2ème étage Québec (Québec) G1R 4X6 Téléphone : (418)647-6756 Courriel : [email protected] Site Web : www.cptaq.gouv.qc.ca -- [email protected] https://inverse.ca/sogo/lists
