dimitri / pgloader

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

syntax error: timestamp and geometry #1621

Open wkgreat opened 2 weeks ago

wkgreat commented 2 weeks ago

postgresql to postgresl load
print this error message

2024-11-07T06:30:57.762000Z ERROR Database error 42601: syntax error at or near "("                                                                             
QUERY: CREATE TABLE "public"."vm_warning_order_t"                                                                                                               
(                                                                                                                                                               
...                                                                                                                
  "judge_time"             timestamp without time zone(6) default NULL,                                                                                         
  "modifier_date"          timestamp without time zone(6) default NULL,                                                                                         
  "create_time"            timestamp without time zone(6) default NULL,                                                                                         
...                                                                                                             
  "geom"                   geometry(4326) default NULL,                                                                                                         
...                                                                                          
);   

According to source table schema, timestamp without time zone(6) should be timestamp(6) and geometry(4326) should be geometry(POINT,4326)
How to fix it?