pgsql: psql: show cloned triggers in partitions

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql: show cloned triggers in partitions
Date: 2018-06-29 16:05:25
Message-ID: E1fYvtl-0005Ab-G0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

psql: show cloned triggers in partitions

In a partition, row triggers that had been cloned from their parent
partitioned table would not be listed at all in psql's \d, which could
surprise users, per insistent complaint from Ashutosh Bapat (though his
aim was elsewhere). The simplest possible fix, suggested by Peter
Eisentraut, seems to be to list triggers marked as internal if they have
a row in pg_depend that points to some other trigger.

Author: Álvaro Herrera
Discussion: https://postgr.es/m/20180618165910.p26vhk7dpq65ix54@alvherre.pgsql

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/bc87f22ef6ef1137909ed7363976c67cf1efa7da

Modified Files
--------------
src/bin/psql/describe.c | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2018-06-29 16:57:56 Re: pgsql: Fix "base" snapshot handling in logical decoding
Previous Message Alvaro Herrera 2018-06-29 15:50:42 pgsql: Fix crash when ALTER TABLE recreates indexes on partitions