Idle idea for a feature - Mailing list pgsql-hackers

From Tom Lane
Subject Idle idea for a feature
Date
Msg-id 25451.1176214490@sss.pgh.pa.us
Whole thread Raw
Responses Re: Idle idea for a feature  (Stephen Frost <sfrost@snowman.net>)
Re: Idle idea for a feature  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: Idle idea for a feature  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
psql's \d command tells you about outgoing foreign key constraints
(ie, ones referencing another table from this one).  It doesn't tell
you about incoming ones (ie, ones where another table references this
one).  ISTM it'd be a good idea if it did, as "are there any incoming
foreign keys" seems to be a question we constantly ask when solving
update-performance problems, and there isn't any easy way to check for
such.  I'm not real sure what the printout should look like, though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "select ('{}'::text[])[1]" returns NULL -- is it correct?
Next
From: Tom Lane
Date:
Subject: Re: Anyone interested in improving postgresql scaling?