I have a requirement to upload data to an instance of PostGreSQL in Amazon RDS. I can do this successfully with the PG ODBC connector but it is very slow. When using the PG Bulk Uploader I get the following error: Current transaction is aborted, commands ignored until end of transaction block. Usually when I see this error, it means there's some sort of mismatch in data types or field size between what I'm trying to upload and the destination table. But I had success with the same data set using the ODBC connector. Any insight would be much appreciated!
