Cannot import SQLite array columns for various types into PostgreSQL (TEXT[]
, NUMERIC[]
, BYTE[]
)
#1552
Open
5 tasks done
It seems like the pgloader grammer simply cannot handle
<TYPE>[]
, leading to inability to parse these files at all. I was just trying to import a misc app into Postgres, so I'm not exactly sure what the type is (JSON? Something else?) but the application bootstrapped the Postgres tables with columns that had the exact same types so PostgreSQL clearly supports the same thing.Specifically, the SQLite's column types were
text[] defaut '{}'
. The postgres bootstrapped tables appear to betext[] NULL [{}]
(I didn't check if the former syntax is compatible).pgloader --version
did you test a fresh compile from the source tree?
I did not, but I saw no changes on HEAD which would appeared related to this issue.
did you search for other similar issues?
SQLITE-TYPE-NAME
parsing, such as:NUMERIC[]
)BYTE[]
)how can I reproduce the bug?
# pgloader command (plain ol' import) pgloader /tmp/test.db postgresql://localhost/testdb
The text was updated successfully, but these errors were encountered: