dimitri / pgloader

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

Cannot cast char to varchar using load file #1525

Open nhirshler opened 1 year ago

nhirshler commented 1 year ago

pgloader version "3.6.7~devel"

I used the latest available image

there are many issues report to the casting but I didn't find exactly the same error

I created the following my.load file:

LOAD DATABASE FROM mysql....... INTO pgsql......

WITH quote identifiers

CAST char TO varchar keep typemod ;

this is the error message I get on running pgloader my.load

KABOOM! ESRAP-PARSE-ERROR: At

CAST char TO varchar keep typ ^ (Line 7, Column 5, Position 170)

In context CASTS:

While parsing CASTS. Expected:

 the character Tab

or the character Newline or the character Return or the character Space or the string "--" or the string "/*" or the string "column" or the string "type" An unhandled error condition has been signalled: At

Any idea?