Postgres Pro
Downloads
Home   >   mailing lists

Re: PG wiki updated with query to show unindexed foreign keys - Mailing list pgsql-admin

From bricklen
Subject Re: PG wiki updated with query to show unindexed foreign keys
Date
Msg-id CAGrpgQ-UwuVdMwMoXVBsDmnQLGzjT8GH1ZBULu_zXcLkWneCkg@mail.gmail.com
Whole thread Raw
In response to Re: PG wiki updated with query to show unindexed foreign keys  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: PG wiki updated with query to show unindexed foreign keys  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
On Tue, Jul 9, 2013 at 5:02 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Jul 7, 2013, at 5:29 PM, bricklen wrote:

> Suggestions and feedback welcome on the query referenced in the link above.

Lack of quoting of identifiers means that it will croak on a database that uses mixed-case identifiers.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

I've updated the wiki (https://wiki.postgresql.org/wiki/Unindexed_foreign_keys) to reflect your suggestion.

Thanks!

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: PG wiki updated with query to show unindexed foreign keys
Next
From: Scott Ribe
Date:
Subject: Re: PG wiki updated with query to show unindexed foreign keys