On Jul 9, 2013, at 6:29 PM, bricklen wrote: > On Tue, Jul 9, 2013 at 5:02 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx > 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! Indeed ;-) It now works on my database that carries a mixed-case naming convention from before I switched to PG (actually, from before PG existed)... And it flagged some that I need to fix! -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
