Skip to content

The value NIL is not of type PGLOADER.CATALOG:COLUMN #1677

@teeravee

Description

@teeravee

Hi,

I try to load data of Metabase from MySQL to PostgreSQL using pgloader but always get the error message The value NIL is not of type PGLOADER.CATALOG:COLUMN.

  • pgloader --version
pgloader version "3.6.7~devel"
compiled with SBCL 2.2.9.debian
  • pgloader output you obtain
    The value NIL is not of type PGLOADER.CATALOG:COLUMN

Full debug log: https://gist.github.com/teeravee/1f757eb1e2e7f7bb1402d02195191c79

LOAD DATABASE
     FROM mysql://username:[email protected]:3306/mysql_metabase
     INTO postgresql://username:[email protected]:5432/psql_metabase?sslmode=require

ALTER SCHEMA 'mysql_metabase' RENAME TO 'public'

with include drop, create tables, create indexes, reset sequences,
     workers = 2

set work_mem to '16MB', maintenance_work_mem to '512 MB';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions