Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with trigger makes Detail record be invalid - Mailing list pgsql-general

From PegoraroF10
Subject Re: Problem with trigger makes Detail record be invalid
Date
Msg-id 1524188994110-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Problem with trigger makes Detail record be invalid  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses Re: Problem with trigger makes Detail record be invalid
List pgsql-general
Tree view 
Correct, that delete done a partial commit. And this is absolutely
unacceptable.
I know I did that trigger incorrectly but referential integrity is
obligatory.
Imagine if I have a database crash and need to restore as soon as possible.
How much time I´ll spend removing those records from a backup to get entire
database restored properly.

Well, I´ll review all my triggers. And I have hundreds of them.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Dynamically filtering a CTE?
Next
From: Stefan Fercot
Date:
Subject: Re: Doubts about replication..