automatically deletion of objects

Jaromír Talíř jaromir.talir at nic.cz
Wed Jan 21 13:44:52 CET 2009


The simplest way is:

-- state_id=1 means ServerDeleteProhibited (check enum_object_states)
INSERT INTO object_state_request (object_id,state_id) values (ID,1);
SELECT update_object_states(ID);

Regards,
Jaromir

Petur Kirke píše v Čt 08. 01. 2009 v 13:33 +0000:
> ________________________________________
> Fra: Petur Kirke
> Sendt: 24. november 2008 13:23
> Til: fred-users at lists.nic.cz
> Emne: SV: automatically deletion of objects
> 
> can you please help me with writing the sql-command with ServerDeleteProhibited ?
> 
> 
> ________________________________________
> Fra: fred-users-bounces at lists.nic.cz [fred-users-bounces at lists.nic.cz] På vegne af Jaromír Talíř [jaromir.talir at nic.cz]
> Sendt: 19. november 2008 11:05
> Til: fred-users at lists.nic.cz
> Emne: Re: automatically deletion of objects
> 
> Of course you can mark them with state ServerDeleteProhibited as
> described earlier for state ServerOutzoneManual.
> 
> Jaromir
> 
> On Fri, 2008-11-14 at 17:44 +0000, Petur Kirke wrote:
> > FRED has a regular procedure that automatically delete
> > contacts, nssets and keysets that are 6 month unattached and unmodified.
> >
> > Is it possible to mark certain contacts, or set a state, so they will NOT be deleted, even if they are 6 months unattached and unmodified ?
> >
> > This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed.
> > If you are not the intended recipient or authorized to receive information for the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. If the email contains proposals, they are valid for 30 days following the date of email transmission. Finally, the recipient should check this email and any attachment for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by email.
> > _______________________________________________
> > Fred-users mailing list
> > Fred-users at lists.nic.cz
> > https://lists.nic.cz/mailman/listinfo/fred-users
> 
> This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed.
> If you are not the intended recipient or authorized to receive information for the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. If the email contains proposals, they are valid for 30 days following the date of email transmission. Finally, the recipient should check this email and any attachment for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by email.
> _______________________________________________
> Fred-users mailing list
> Fred-users at lists.nic.cz
> https://lists.nic.cz/mailman/listinfo/fred-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3870 bytes
Desc: not available
Url : http://lists.nic.cz/pipermail/fred-users/attachments/20090121/30480e02/attachment.bin 


More information about the Fred-users mailing list