Bug #570: \d in psql does not show triggers

Gerald Vogt (gv_de(at)yahoo(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
\d in psql does not show triggers

Long Description
When using \d in psql to find details of a table, occasionally
triggers will not be listed although the table does have triggers. This happens when the table does not have any rules.

e.g.:

SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules from pg_class where relname='pub_liste';
relhasindex | relkind | relchecks | reltriggers | relhasrules
-------------+---------+-----------+-------------+-------------
t | r | 0 | 25 | f
(1 row)

However:

\d pub_liste
Table "pub_liste"
Attribute | Type | Modifier
-----------+-----------------------+----------
...
Index: pub_liste_pkey

This is due to a bug in bin/psql/describe.c line 793
< if (!error && tableinfo.hasrules)
should probably be
> if (!error && tableinfo.triggers)

Gerald

Sample Code

No file was uploaded with this report