method

pk_and_sequence_for

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

pk_and_sequence_for(table) public

Returns a table’s primary key and belonging sequence.

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 822
      def pk_and_sequence_for(table) #:nodoc:
        # First try looking for a sequence with a dependency on the
        # given table's primary key.
        result = exec_query(          SELECT attr.attname, seq.relname          FROM pg_class seq          INNER JOIN pg_depend dep ON seq.oid = dep.objid          INNER JOIN pg_attribute attr ON attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid          INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]          WHERE seq.relkind  = 'S'            AND cons.contype = 'p'            AND dep.refobjid = '#{quote_table_name(table)}'::regclass, 'SCHEMA').rows.first

        # [primary_key, sequence]
        [result.first, result.last]
      rescue
        nil
      end

pk_and_sequence_for

Related methods

Flowdock - Team Inbox With Chat