1. Duane King
  2. Valentina Studio
  3. Samstag, November 04 2017, 11:20 PM
  4.  Abonnieren via E-Mail
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 :(
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
Duane King Akzeptierte Antwort
Its also choking on the `CREATE EXTENSION IF NOT EXISTS "uuid-ossp";` line
Kommentar
There are no comments made yet.
Duane King Akzeptierte Antwort
Kommentar
There are no comments made yet.
  • Seite :
  • 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