pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

empty table breaks?

Open j2l opened this issue 3 years ago • 0 comments
trafficstars

  • [x] pgloader --version
pgloader version "3.6.2"
compiled with SBCL 2.0.6.debian
  • [ ] did you test a fresh compile from the source tree?

  • [x] did you search for other similar issues?

  • [x] how can I reproduce the bug? postgres is running fine in a local container: pgloader --type csv --with "drop indexes" --with "fields terminated by ','" --with truncate ./export.csv postgres://postgres:[email protected]:5432/anvil?tablename="csv_todos" results in:

2022-05-09T14:43:18.016000Z LOG pgloader version "3.6.2"
KABOOM!
FATAL error: pgloader found 0 target tables for name csv_todos:
An unhandled error condition has been signalled:
   pgloader found 0 target tables for name csv_todos:




What I am doing here?

pgloader found 0 target tables for name csv_todos:

export.csv (utf-8):

"ID","desc","done","user"
"[242374,410726810]","test a",0,"#ROW[242390,410710855]"

the table is created with Adminer: image

I expect pgloader to create columns with type according to data, I might be wrong :)

j2l avatar May 09 '22 14:05 j2l