1. Duane King
  2. Valentina Studio
  3. Saturday, November 04 2017, 11:20 PM
  4.  Subscribe via 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 :(
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Duane King Accepted Answer
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Duane King Accepted Answer
Its also choking on the `CREATE EXTENSION IF NOT EXISTS "uuid-ossp";` line
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
  • 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