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.
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. # 1
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. # 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories