Re: psql: show which tables contraints are for with a \d - Mailing list pgsql-patches

From Tom Lane
Subject Re: psql: show which tables contraints are for with a \d
Date
Msg-id 4686.1029474906@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql: show which tables contraints are for with a \d  (Rod Taylor <rbt@zort.ca>)
Responses Re: psql: show which tables contraints are for with a \d  (Rod Taylor <rbt@zort.ca>)
List pgsql-patches
Rod Taylor <rbt@zort.ca> writes:
> It should be noted that my patch in the queue displays the actual
> foreign key definition and suppresses 'Constraint' Triggers.

> This is a touch better than the below with the side effect that if a
> user issues a CREATE CONSTRAINT TRIGGER manually it is mistakenly
> hidden.

I was thinking of looking into pg_depend to discover whether a trigger
is associated with a constraint, and hiding the trigger if and only if
we have a constraint to show instead.  Anyone want to pursue that?

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: improve SET CONSTRAINTS
Next
From: "Christopher Kings-Lynne"
Date:
Subject: pg_stat_reset round 4