Copy statement fails silently if append target does not already exist

chop-dbhi / dataexpress

[NOT MAINTAINED] DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite

http://dataexpress.research.chop.edu

BSD 2-Clause "Simplified" License

72 stars 9 forks source link

Copy statement fails silently if append target does not already exist #44

Open bruth opened 10 years ago

bruth commented 10 years ago

The behavior I expect is for the table to be created if it does not already exist prior to appending.

Seems to be related to #42

bruth commented 10 years ago

One clarification is that it silently failed when no records needed to be inserted. It did of course fail when an insert was attempted and the table did not exist. I still think it should implicitly create the table if it doesn't already exist.