1. B M
  2. Valentina Studio
  3. Saturday, March 23 2019, 09:00 PM
  4.  Subscribe via email
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.
Attachments (3)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello,

Thank you, we’ll fix it in the next version.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
B M Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • Page :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories