Monkey patch postgres adapter for postgres 9 support
authorTom Hughes <tom@compton.nu>
Sun, 3 Apr 2011 16:39:06 +0000 (17:39 +0100)
committerTom Hughes <tom@compton.nu>
Sun, 3 Apr 2011 16:39:06 +0000 (17:39 +0100)
config/initializers/postgresql_adapter.rb

index d8f8495..6e77a3f 100644 (file)
@@ -2,6 +2,13 @@ if defined?(ActiveRecord::ConnectionAdaptors::PostgreSQLAdaptor)
   module ActiveRecord
     module ConnectionAdapters
       class PostgreSQLAdapter
+        def supports_disable_referential_integrity?() #:nodoc:
+          version = query("SHOW server_version")[0][0].split('.')
+          (version[0].to_i >= 9 || (version[0].to_i == 8 && version[1].to_i >= 1)) ? true : false
+        rescue
+          return false
+        end
+
         def pk_and_sequence_for(table)
           # First try looking for a sequence with a dependency on the
           # given table's primary key.