1. B M
  2. Valentina Studio
  3. 土, 3月 23 2019, 09:00 PM
  4.  メールで購読
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.
添付ファイル
コメント
There are no comments made yet.
B M 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello,

Thank you, we’ll fix it in the next version.
コメント
There are no comments made yet.
  • ページ :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories