1. B M
  2. Valentina Studio
  3. Samstag, März 23 2019, 09:00 PM
  4.  Abonnieren via E-Mail
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.
Anhänge
Kommentar
There are no comments made yet.
B M Akzeptierte Antwort
Additional observation. After adding missing schema into SEARCH_PATH before running the data transfer utility, everything works as expected. However, it would be nice if the functionality was smart enough to acquire it directly from a table selected or at least give a warning to set it beforehand.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello,

Thank you, we’ll fix it in the next version.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.