dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.45k stars 548 forks source link

pgloader fails to import SQLite database with timestamp column #1523

Open bnovc opened 1 year ago

bnovc commented 1 year ago
not using load files - I tried that, and they run without failing but no tables are created
2023-08-25T14:17:37.010194-04:00 LOG pgloader version "3.6.9"
2023-08-25T14:17:37.011417-04:00 LOG Data errors in '/private/tmp/pgloader/'
2023-08-25T14:17:37.048070-04:00 LOG Migrating from #<SQLITE-CONNECTION sqlite:///Users/..../Documents/./....20230823.db {700BA565B3}>
2023-08-25T14:17:37.048162-04:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://....@UNIX:5432/... {700BC12C13}>
2023-08-25T14:17:37.124031-04:00 ERROR Database error 22007: invalid input syntax for type timestamp with time zone: "current_timestamp"
QUERY: CREATE TABLE queries 
(
  id          bigint,
  "user"      text,
  query       text,
  json        text,
  num_results int,
  ran_at      timestamptz default 'current_timestamp'
);
2023-08-25T14:17:37.124121-04:00 FATAL Failed to create the schema, see above.
2023-08-25T14:17:37.124150-04:00 LOG report summary reset
       table name     errors       rows      bytes      total time
-----------------  ---------  ---------  ---------  --------------
            fetch          0          0                     0.000s
  fetch meta data          0         16                     0.019s
   Create Schemas          0          0                     0.001s
 Create SQL Types          0          0                     0.002s
    Create tables          0          0                     0.000s
-----------------  ---------  ---------  ---------  --------------
-----------------  ---------  ---------  ---------  --------------
PASTE HERE THE DATA THAT HAS BEEN LOADED
rowild commented 1 year ago

Same problem here...