From: | iurii(dot)i(dot)popov(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14310: Triggers do not fire |
Date: | 2016-09-05 09:30:26 |
Message-ID: | 20160905093026.1404.37078@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14310
Logged by: Iurii Popov
Email address: iurii(dot)i(dot)popov(at)gmail(dot)com
PostgreSQL version: 9.4.9
Operating system: Linux 8 (jessie)
Description:
We have a repeating problem with triggers and handles in foreign keys since
we have updated PostgreSQL.
There are two projects with PostgreSQL 9.2.17 and 9.4.9 respectively. We do
not have the problem with 9.2.16 and 9.4.4 versions.
By accident a BEFORE INSERT FOR EACH ROW triggers do not fire and handles in
foreign keys (ON DELETE SET NULL and ON DELETE CASCADE) do not fire.
If we do actions by hands (INSERT or DELETE) everything works but with
people online we have this problem by accident.
From | Date | Subject | |
---|---|---|---|
Next Message | fabien.combernous | 2016-09-05 12:11:42 | BUG #14311: ERROR: must be owner of extension plpgsql |
Previous Message | noloader | 2016-09-04 04:45:59 | BUG #14309: SSL_get_current_compression magic from port.h breaks compile against OpenSSL 1.1.0 |