Trigger does not work after partitioning

From: "Raschkowski, Michael" <michael(dot)raschkowski(at)auconet-it(dot)com>
To: <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Cc: "Hartmut Bolten" <hartmut(dot)bolten(at)auconet-it(dot)com>, "Hannes Just" <hannes(dot)just(at)auconet-it(dot)com>
Subject: Trigger does not work after partitioning
Date: 2020-03-19 16:44:59
Message-ID: 001c01d5fe0d$baddddb0$30999910$@auconet-it.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I am using Postgres 12.1 on Windows 10.

I wrote the script for the partitioning of some tables and have noticed that
some triggers do not work after partitioning. In attached example, you can
see that the table test1 gets a trigger that sets the field instancenbr to 1
after each insertion. Nevertheless, the field instancenbr stays to have
NULL-Value.

Is it a bug or I have not taken something into account?

Thanks in advance!

Viele Grüße / Kind regards,

Dr. Michael Raschkowski
Software Architect

Auconet GmbH - ein Unternehmen der Beta Systems Gruppe
An den Treptowers 1, 12435 Berlin
Phone: +49 30 254 690-356
Fax: +49 30 254 690-199
Email: <mailto:michael(dot)raschkowski(at)auconet-it(dot)com>
michael(dot)raschkowski(at)auconet-it(dot)com
<http://www.auconet-it.com/> www.auconet-it.com

Mandatory Information for business emails according to German trade laws /
Pflichtangaben für geschäftliche E-mails gemäß Handelsgesetzbuch:

Auconet GmbH - ein Unternehmen der Beta Systems Gruppe
An den Treptowers 1
12435 Berlin
Germany
Phone: +49-(0)30-254 690-0
Fax: +49-(0))30-254 690-199
<mailto:info(at)auconet-it(dot)com> info(at)auconet-it(dot)com
<http://www.auconet-it.com/> www.auconet-it.com

Management / Geschäftsführer: Hartmut Bolten, Sebastian Zang
Legal form / Rechtsform: GmbH | Registered office / Sitz: Berlin
Commercial register / Handelsregister: Amtsgericht Charlottenburg HRB 141
887 B
VAT-ID / Ust-ID-Nr.: DE316422231 | Tax No. / St.-Nr.: 30/036/75431
Bank / Bankverbindung: Commerzbank AG, BIC: COBADEFF, IBAN: DE25 1004 0000
0230 9391 00

Attachment Content-Type Size
error_part_trigger.sql application/octet-stream 928 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2020-03-19 17:42:57 Re: Trigger does not work after partitioning
Previous Message Tom Lane 2020-03-19 13:33:36 Re: BUG #16302: too many range table entries - when count partition table(65538 childs)