Re: [ADMIN] PG wiki updated with query to show unindexed foreign keys

2013-07-09 Thread Scott Ribe
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_r...@elevated-dev.com http://www.elevated-dev.co

Re: [ADMIN] PG wiki updated with query to show unindexed foreign keys

2013-07-09 Thread bricklen
On Tue, Jul 9, 2013 at 5:02 PM, Scott Ribe 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. > > -- >

Re: [ADMIN] PG wiki updated with query to show unindexed foreign keys

2013-07-09 Thread Scott Ribe
On Jul 9, 2013, at 6:29 PM, bricklen wrote: > On Tue, Jul 9, 2013 at 5:02 PM, Scott Ribe > 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 dat

Re: [ADMIN] PG wiki updated with query to show unindexed foreign keys

2013-07-09 Thread bricklen
On Tue, Jul 9, 2013 at 5:34 PM, Scott Ribe wrote: > 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! > Everyone wins!