'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 |
|---|
