'How to reactivate a trigger after enable it

I want to reactivate a trigger after enable it but I don't find any solution to my problem. I work on postgresql database.

I used the following command to enable my trigger logmodif_contact

ALTER TABLE contact_sas enable TRIGGER logmodif_contact;

After that I use the command that throw me true to indicate the trigger is enabled.

    SELECT  tgenabled
    FROM    pg_trigger
    WHERE   tgname='logmodif_contact' AND
            tgenabled != 'D'
); 

And now the trigger is enabled I can do my work but after that I must reactivate it to insure the database integrity.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source