BUG #14310: Triggers do not fire

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.

Responses

Browse pgsql-bugs by date

  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