Hello,
Is it possible to completely delete records in postgresql database, which have N-status (deleted; logical deletion) without changing the code of the application?
Thanks in advance
We're sorry, but this operation is forbidden for security reasons (in order to maintain the consistency of the database)
If you need to delete these cards you should disable all the triggers and delete the cards and also their relations (inside the Map_xxx tables) to preserve data consistency .
Kind regards,
Lisa
Many thanks for quick reply.
I’ve also come accross this on multiple occasions, I’ve found the best way to deal with this and to keep your DB clean is to follow a development cycle which means only guaranteed to work attributes and classes are added to the live schema.
Otherwise you end up with a bit of a mess in your administration console!
Would be good to have a guide to removing logically deleted content, I'm not sure how to disable triggers!
Thanks,
Jamie