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(a)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(a)lists.nic.cz [fred-users-bounces(a)lists.nic.cz] På vegne
af Jaromír Talíř [jaromir.talir(a)nic.cz]
Sendt: 19. november 2008 11:05
Til: fred-users(a)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(a)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(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users