git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f565f53) | patch
Fix cloning of row triggers to sub-partitions
Thu, 2 Jan 2020 20:04:24 +0000 (17:04 -0300)
Thu, 2 Jan 2020 20:04:24 +0000 (17:04 -0300)
commit adc9cb6f26f785d1e62a0bd86d69974aab1bf6e5
Fix cloning of row triggers to sub-partitions

When row triggers exist in partitioned partitions that are not either
part of FKs or deferred unique constraints, they are not correctly
cloned to their partitions. That's because they are marked "internal",
and those are purposefully skipped when doing the clone triggers dance.
Fix by relaxing the condition on which internal triggers are skipped.

Amit Langote initially diagnosed the problem and proposed a fix, but I
used a different approach.

Reported-by: Petr Fedorov
Discussion: https://postgr.es/m/6b3f0646-ba8c-b3a9-c62d-1c6651a1920f@phystech.edu
src/backend/commands/tablecmds.c diff | blob | blame | history
src/test/regress/expected/triggers.out diff | blob | blame | history
src/test/regress/sql/triggers.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /