From 9d5217db5dce5e61cf3308329d94593a0e1cf6ff Mon Sep 17 00:00:00 2001 From: Ryuta Kamizono Date: Sat, 25 Feb 2017 15:09:05 +0900 Subject: Prefer `USING (column_list)` for joining information_schema --- .../active_record/connection_adapters/postgresql/schema_statements.rb | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'activerecord') diff --git a/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb b/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb index aaa67a9ea2..f7f3a1521b 100644 --- a/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb +++ b/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb @@ -367,9 +367,7 @@ module ActiveRecord SELECT column_name FROM information_schema.key_column_usage kcu JOIN information_schema.table_constraints tc - ON kcu.table_name = tc.table_name - AND kcu.table_schema = tc.table_schema - AND kcu.constraint_name = tc.constraint_name + USING (table_schema, table_name, constraint_name) WHERE constraint_type = 'PRIMARY KEY' AND kcu.table_name = #{scope[:name]} AND kcu.table_schema = #{scope[:schema]} -- cgit v1.2.3