1. Duane King
  2. Valentina Studio
  3. Суббота, Ноябрь 04 2017, 11:20 PM
  4.  Подписаться через email
I am trying to use the PostgreSQL uuid type in my database, and I notice that despite wide support for it and the actual intention for me to use it in my end database, its missing from the type list in the pulldown menu. I'm not sure what to do as at this point, it's a $200 pice f software I cant use for my intended use case, as it also refuses to import any sql file that uses this type.

How am I supposed to use this type? Am I able to add it myself so that imports work and I can graph the current production schema? What should I do given that this will be my primary key type for many many tables, it's in production, it works perfectly, this is by design, and I just want to get work done?

Please don't tell me not to use a UUID type, that's not an answer we will/can accept. It's running in production fine, I just want to import our sql into my purchased copy of valentina and map it, extend it, etc, and valentina doesn't seem to support PostgreSQL very well so far as all attempts to import valid PostgreSQL code fail and I'm not sure what to do as I just want to get work done :(
Комментарий
There are no comments made yet.
Duane King Ответ принят
Комментарий
There are no comments made yet.
Duane King Ответ принят
Its also choking on the `CREATE EXTENSION IF NOT EXISTS "uuid-ossp";` line
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Duane,

So you import SQL dump of PostgreSQL database into a new PostgreSQL database in the Valentina Studio?
And there are some UUID-related errors? Which exactly?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
UUID type is in the menu.

Please make sure you're using PostgreSQL connection for this task and not Valentina Files, SQLite Files, not MySQL, etc.
Вложения
Комментарий
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories