hi,
need help to cast custom type in sqlite, my sqlite file have this structure
CREATE TABLE item (
id TEXT,
description TEXT,
um TEXT,
method_set INTEGER,
method_default INTEGER,
method_grid NUMERIC[],
method_graph NUMERIC[], level INTEGER DEFAULT 0, active INTEGER DEFAULT 0,
PRIMARY KEY(id)
);
data example on method_grid data [1,2]
data example on method_graph [3,4]
thanks
[ ] pgloader --version
pgloader version "3.6.999791d" compiled with SBCL 1.4.16.debian
[ ] did you test a fresh compile from the source tree?
yes
[ ] did you search for other similar issues?
yes
[ ] how can I reproduce the bug?
--
-pgloader -v -d --context ./pgloader.ini -L pgloader.log -D workdir -S pgloader.summary db.load
--
load database
FROM sqlite://$path/project.db
INTO postgresql://{{PGUSER}}:{{PGPASSWORD}}@{{DBHOST}}/{{DB}}
WITH include drop, create tables, create indexes, reset sequences
SET PostgreSQL PARAMETERS maintenance_work_mem to '1024MB', work_mem to '1024', search_path to '$schemanum'
CAST
type date drop not null drop default using zero-dates-to-null,
type datetime to timestamp drop default using zero-dates-to-null
BEFORE LOAD DO
$$ drop schema IF EXISTS $schemanum cascade; $$,
$$ create schema $schemanum; $$;
- [ ] pgloader output you obtain
2023-10-06T17:43:13.069000+02:00 SQL SQLite: SELECT tbl_name
FROM sqlite_master
WHERE tbl_name = 'sqlite_sequence'
2023-10-06T17:43:13.075000+02:00 SQL SELECT tbl_name
FROM sqlite_master
WHERE type='table'
AND tbl_name <> 'sqlite_sequence'
2023-10-06T17:43:13.082000+02:00 ERROR sqlite: At
numeric[]
^ (Line 1, Column 7, Position 7)
In context SQLITE-TYPE-NAME:
While parsing SQLITE-TYPE-NAME. Problem:
The production
#\]
does not satisfy the predicate ALPHA-CHAR-P.
Expected:
the character _ (LOW_LINE)
or any character satisfying ALPHA-CHAR-P
or
2023-10-06T17:43:13.082000+02:00 LOG report summary reset
2023-10-06T17:43:13.107000+02:00 INFO Stopping monitor
hi, need help to cast custom type in sqlite, my sqlite file have this structure CREATE TABLE item ( id TEXT, description TEXT, um TEXT, method_set INTEGER, method_default INTEGER, method_grid NUMERIC[], method_graph NUMERIC[], level INTEGER DEFAULT 0, active INTEGER DEFAULT 0, PRIMARY KEY(id) );
data example on method_grid data [1,2] data example on method_graph [3,4]
thanks
[ ] pgloader --version
[ ] did you test a fresh compile from the source tree?
yes
[ ] did you search for other similar issues?
yes
[ ] how can I reproduce the bug?
2023-10-06T17:43:13.069000+02:00 SQL SQLite: SELECT tbl_name FROM sqlite_master WHERE tbl_name = 'sqlite_sequence' 2023-10-06T17:43:13.075000+02:00 SQL SELECT tbl_name FROM sqlite_master WHERE type='table' AND tbl_name <> 'sqlite_sequence'
2023-10-06T17:43:13.082000+02:00 ERROR sqlite: At
numeric[] ^ (Line 1, Column 7, Position 7)
In context SQLITE-TYPE-NAME:
While parsing SQLITE-TYPE-NAME. Problem:
The production
#\]does not satisfy the predicate ALPHA-CHAR-P.
Expected:
or any character satisfying ALPHA-CHAR-P or
2023-10-06T17:43:13.082000+02:00 LOG report summary reset
2023-10-06T17:43:13.107000+02:00 INFO Stopping monitor
no data