referential integrity without trigger
От | Alexander Presber |
---|---|
Тема | referential integrity without trigger |
Дата | |
Msg-id | 302F3CB4-1087-4AAD-A23A-C9AE1C3FDFD9@weisshuhn.de обсуждение исходный текст |
Ответы |
Re: referential integrity without trigger
Re: referential integrity without trigger |
Список | pgsql-general |
Hello everybody, Assuming I want to empty and refill table A (with roughly the same content, preferrably in one transaction) and don't want to completely empty a dependent table B but still keep referential integrity after the commit. Without disabling A's on-delete-trigger B will be be emptied on commit, even when I inserted exactly the same data into A that I deleted an instant before. That is because the trigger gets called on commit, no matter if the deleted rows have "reappeared". If I disable the trigger, My referential integrity is most likely corrupted. Is there a clever, general scheme to "recheck" and enforce foreign key contraints, after the responsible triggers have been disabled and reenabled? I hope this makes sense to you. Alexander Presber
В списке pgsql-general по дате отправления: