method

reset_pk_sequence!

v3.2.8 - 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 924
      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 @logger && pk && !sequence
          @logger.warn "#{table} has primary key #{pk} with no default sequence"
        end

        if pk && sequence
          quoted_sequence = quote_table_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), 'Reset sequence'
        end
      end

reset_pk_sequence!

Related methods

Flowdock - Team Inbox With Chat for Software Developers