Your feedback is highly appreciated! Let's make Vertabelo even better.

0

New Oracle physical data model "from SQL" requires columns to be listed for the referenced table

Aner Perez 4 hours ago 0

When creating a new model from an existing SQL DDL script (i.e. Content: "from SQL" is selected), the import fails if the table has a foreign key constraint with no columns listed on the foreign table.  In that situation it should use the primary key for the referenced table as the referenced columns.  Instead I received a cryptic error of ERROR:No more content.


A sample DDL that demonstrates this behavior is:


CREATE TABLE person (
  id NUMBER(6) NOT NULL,
  first_name VARCHAR2(30) NOT NULL,
  last_name VARCHAR2(30) NOT NULL,
  changed_by NUMBER(6) NOT NULL,
  CONSTRAINT person#PK
    PRIMARY KEY (id),
  CONSTRAINT person#person#FK
    FOREIGN KEY (changed_by)
    REFERENCES person
);

I would need to change the last line to say REFERENCES person (id) for this DDL to be accepted.  This DDL was from a very old Oracle database and I selected 11c/12g as the version.

0

DDL Import | Import SQL failing on gen_random_uuid() and timezone('utc'::text, now())

Bryan Lam 7 hours ago updated 7 hours ago 0

The import SQL parser seems to not like `gen_random_uuid()`(supported in Postgres 13) when that is set as the default. It is also failing to parse`timezone('utc'::text, now())`(supported in Postgres 13).

I've been resorting to deleting these from my sql file just so I can get the table to import.

Example:

CREATE TABLE public.skill (
    title character varying NOT NULL,
    description text,
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    created_at timestamp without time zone DEFAULT timezone('utc'::text, now()) NOT NULL,
    updated_at timestamp without time zone DEFAULT timezone('utc'::text, now()) NOT NULL,
    deleted_at timestamp without time zone
);

To get it to import I have to delete those:

CREATE TABLE public.skill (
    title character varying NOT NULL,
    description text,
    id uuid NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    deleted_at timestamp without time zone
);

Would be nice to have the import accommodate these functions so I don't have to keep editing my sql files before import.

0
Started

Table Shorcut not Working for Physical Models

Robby Ciliberto 2 weeks ago updated 2 weeks ago 2

When trying to make a physical model, I cannot make use of table shortcuts. The option to create a shortcut does not appear when right clicking a table and dragging the table from the navigation pane does nothing either. This issue does not occur when making a logical model, however.

Using Google Chrome on Mac with no extensions enabled. My account is an educational account if that makes a difference.

Image 1328

0
Not a bug

Academic Account Problem

Jakub Wojtowicz 2 weeks ago updated by Jarosław Błąd (CEO) 2 weeks ago 1

I created my account following steps of the instruction "how to create an academic account", but it didn't work and my trial period ended. Please help me get an academic account, it would really help me with my college project.

+1
Not a bug

Missing UUID column type for PostgreSQL

Shane Tarleton 7 years ago updated by Jarosław Błąd (CEO) 2 weeks ago 5

The UUID datatype for PostgreSQL is missing and is valid in 9.0+ versions.

https://www.postgresql.org/docs/9.5/static/datatype-uuid.html

Answer

Hello,


It is just missing on the list but you can type it.


0
Answered

The take control feature is taking hours to load

Giorgos Geroukos 3 weeks ago updated by Jarosław Błąd (CEO) 2 weeks ago 1

Whenever I try and take control of my physical data model, it takes hours to happen. Is there any way to fix this

0
Answered

What are all the Platforms supported in this tool. Like Windows, MAC?

Janani Vijayakumar 1 month ago updated by Jarosław Błąd (CEO) 4 weeks ago 1
0
Completed

How can I reverse engineering from MS SQL Server

salvadord441 2 years ago updated by Rafał Strzaliński (Senior Engineer) 1 month ago 9

How can I reverse engineering from MS SQL Server? I am trying to generate a model from an existing Database in MS SQL.

0
Answered

How to update the existing model using reverse engineering?

Janani Vijayakumar 1 month ago updated by Jarosław Błąd (CEO) 1 month ago 1

I have initially created a model using reverse engineering. Then i have  made few changes to my database. Now again i am trying to connect to my database using reverse engineering and sync the changes to the same model.

0
Answered

How much volume of database can Vertabelo handle for reverse enginneering?

janani vijay04 1 month ago updated by Jarosław Błąd (CEO) 1 month ago 1