There is something strange going on with data transfer in Studio Pro. First some background:
1. Source db: Postgres 11
2. Target db: Postgres 10
The Postgres version should make no difference as we are talking about a simply table mapping.
Problem:
After mapping tables on both sides and trying to perform a transfer, I get an error "relation <table> does not exist..." But it does. The only thing I can think of is that you do not fully qualify tables on both sides (no schema provided) and because those schemas are not part of a search path, PostgreSQL cannot find it. It's a shame because this would be a great feature to transfer/compare data between local and remote databases for me...
Can you look into this, please? I am attaching a screen-shot of the error and mapping. "sql error.png" seems to confirm my theory about table names not being fully qualified with a schema name they reside in.