Re: psql: show which tables contraints are for with a \d

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: psql: show which tables contraints are for with a \d
Дата
Msg-id 4686.1029474906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: psql: show which tables contraints are for with a \d  (Rod Taylor <rbt@zort.ca>)
Ответы Re: psql: show which tables contraints are for with a \d  (Rod Taylor <rbt@zort.ca>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: improve SET CONSTRAINTS
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: pg_stat_reset round 4