Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

syntax error: timestamp and geometry #1621

Open
wkgreat opened this issue Nov 7, 2024 · 0 comments
Open

syntax error: timestamp and geometry #1621

wkgreat opened this issue Nov 7, 2024 · 0 comments

Comments

@wkgreat
Copy link

wkgreat commented Nov 7, 2024

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant