method

set_constraints

v8.1.1 - Show latest stable - Class: ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements

set_constraints(deferred, *constraints)

public

Set when constraints will be checked for the current transaction.

Not passing any specific constraint names will set the value for all deferrable constraints.

deferred: Valid values are :deferred or :immediate.

See www.postgresql.org/docs/current/sql-set-constraints.html

# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 110
        def set_constraints(deferred, *constraints)
          unless %[deferred immediate].include?(deferred)
            raise ArgumentError, "deferred must be :deferred or :immediate"
          end

          constraints = if constraints.empty?
            "ALL"
          else
            constraints.map { |c| quote_table_name(c) }.join(", ")
          end
          execute("SET CONSTRAINTS #{constraints} #{deferred.to_s.upcase}")
        end

set_constraints

Related methods