ankane/pgsync · error · Error

Cannot use parameters with tables

Error message

Cannot use parameters with tables

What it means

Error "Cannot use parameters with tables" thrown in ankane/pgsync.

Source

Thrown at lib/pgsync/task_resolver.rb:71

    def group_to_tasks(value)
      group, param = value.split(":", 2)
      raise Error, "Group not found: #{group}" unless group?(group)

      @groups[group].map do |table|
        table_sql = nil
        if table.is_a?(Array)
          table, table_sql = table
        end

        {
          table: to_table(table),
          sql: expand_sql(table_sql, param)
        }
      end
    end

    def table_to_tasks(value)
      raise Error, "Cannot use parameters with tables" if value.include?(":")

      tables =
        if value.include?("*")
          regex = Regexp.new('\A' + Regexp.escape(value).gsub('\*', '[^\.]*') + '\z')
          shared_tables.select { |t| regex.match(t.full_name) || regex.match(t.name) }
        else
          [to_table(value)]
        end

      tables.map do |table|
        {
          table: table,
          sql: sql_arg # doesn't support params
        }
      end
    end

    # treats identifiers as if they were quoted (Users == "Users")

View on GitHub (pinned to 57bdddf5db)

When it happens

Trigger: Thrown at lib/pgsync/task_resolver.rb:71 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of ankane/pgsync@57bdddf5db (2026-08-23). Data as JSON: /api/errors/8403d2af7a817c3c. Report an issue: GitHub.