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 |
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) |