method

reset_pk_sequence!

v3.0.5 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

reset_pk_sequence!(table, pk = nil, sequence = nil) public

Resets the sequence of a table’s primary key to the maximum value.

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 716
      def reset_pk_sequence!(table, pk = nil, sequence = nil) #:nodoc:
        unless pk and sequence
          default_pk, default_sequence = pk_and_sequence_for(table)
          pk ||= default_pk
          sequence ||= default_sequence
        end
        if pk
          if sequence
            quoted_sequence = quote_column_name(sequence)

            select_value "SELECT setval('\#{quoted_sequence}', (SELECT COALESCE(MAX(\#{quote_column_name pk})+(SELECT increment_by FROM \#{quoted_sequence}), (SELECT min_value FROM \#{quoted_sequence})) FROM \#{quote_table_name(table)}), false)\n", 'Reset sequence'
          else
            @logger.warn "#{table} has primary key #{pk} with no default sequence" if @logger
          end
        end
      end

reset_pk_sequence!

Related methods

Flowdock - Team Inbox With Chat