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

  1. Forum: Vertabelo
0
Besvaret

No university domain

wolterlw 8 år siden • opdateret af Rafał Strzaliński (Senior Engineer) 8 år siden • 3

I study at Igor Sikorsky Kyiv Polytechnic Institute (Ukraine) and we have no university domain as such, we use ukr.net domain for all the university communication though.

How do I create and academic account?

0
Fast

Migration script error - DROP NOT NULL versus SET NOT NULL

Stéphan Doucet 8 år siden • opdateret af anonymous 8 år siden • 3

If I modify a column of a table to allow NULL, the migration script generate this :


ALTER TABLE "myTable"

ALTER "myColumn" SET NOT NULL;


Instead of :


ALTER TABLE "myTable"

ALTER "myColumn" DROP NOT NULL;

0
Afvist

Database normalization

seralalal 8 år siden • opdateret af anonymous 8 år siden • 1

How i can check db. Check for normal form. Do you have templates of normal forms?

0
Færdig

Unable to access Vertableo with my account

Mayur Nayee 9 år siden • opdateret af anonymous 8 år siden • 2

Hi, I had vertabelo account with mailid: mayur.17892@yahoo.com and i have laerned SQL queries course till Correlation Sub queries. Today i tried to open my account but couldn't open and it said that there is no account with my Mail id.

+1
Under vurdering

Graphical representation of UNIQUE columns

Max 8 år siden • opdateret af Rafał Strzaliński (Senior Engineer) 8 år siden • 1

Why isn't there a "U" on the right side next to type like there is a graphical representation for private and foreign keys? I know you can set a variable as unique but it doesn't show in the diagram.

0
Besvaret

Importing New Tables Into Model Erases Existing Content

Matthew Evans 8 år siden • opdateret af Rafał Strzaliński (Senior Engineer) 8 år siden • 1

I am attempting to import a number of new tables into an existing model, but when I do so (using the SQL Script Option) everything that was in the model previously is erased. Is there way to "merge" in these new tables and not have them simply overwrite what is in place?

0
Fast

SQL preview is not working for references

Alexander Yermachenko 9 år siden • opdateret 8 år siden • 4

Actually it was working before new year and now is broken.


Steps to reproduce:

1) Add 2 tables

2) Add reference between then

3) Select reference

4) Press "SQL Preview" button.

Result:

Empty preview (no SQL code except for comments).

0
Ikke en bug

"Type not supported" error for the default varchar in Postgres. Why?

willie witten 9 år siden • opdateret 9 år siden • 2

In developing an ER diagram for Postgres, I always get "type not supported" error for the default varchar. If I don't change anything, it warns me about % sign, if I leave the () blank then I get a warning, which is better than an error, but this isn't great.


Am I missing something?


Thanks,

willie

Svar
anonymous 9 år siden

I believe the behavior is correct. Let's go through all the cases you described.


First of all, the default varchar (that is one without lenght) has syntax: "varchar" or "character varying". You can write it this way in "Type" field and you get no error:


Database accepts it without warning:

tests=> CREATE TABLE def_varchar (
tests(>    id int  NOT NULL,
tests(>    code varchar  NOT NULL,
tests(>    CONSTRAINT def_varchar_pk PRIMARY KEY (id)
tests(> );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "def_varchar_pk" for table "def_varchar"
CREATE TABLE


Then, if you try either "varchar()" or "varchar(%)", both Vertabelo and PostgreSQL will raise an error:


tests=> CREATE TABLE def_varchar (
tests(>    id int  NOT NULL,
tests(>    code varchar()  NOT NULL,
tests(>    CONSTRAINT def_varchar_pk PRIMARY KEY (id)
tests(> );
ERROR:  syntax error at or near ")"
LINE 3:    code varchar()  NOT NULL,
                        ^



tests=> CREATE TABLE def_varchar (
tests(>    id int  NOT NULL,
tests(>    code varchar(%)  NOT NULL,
tests(>    CONSTRAINT def_varchar_pk PRIMARY KEY (id)
tests(> );
ERROR:  syntax error at or near "%"
LINE 3:    code varchar(%)  NOT NULL,
                        ^

Please note that the list of data types is only a helper to choose the most common ones. You can provide any text you want into the "Type" field. Vertabelo either warns you or raises an error if it doesn't recognize the type, but you can ignore it if you like.


Hope this helps.

+4
Færdig

Notes sizing and re-sizing

Rebecca Cremona 10 år siden • opdateret af anonymous 9 år siden • 2
I often use the text notes feature to annotate my tables. It's unfortunate that the notes don't default to a reasonable size, but instead become wider and wider, aiming to fit an entire paragraph on one line. Thanks for letting me re-size, after the fact..... but then, if I go back and edit the text, the notes become hugely wide again, and have to be resized again. Notes should default to a reasonable width, with text-wrapping, and once resized, should keep their specified widths.
+15
Færdig

Selective Table SQL generation

Raymond Gigliotti 11 år siden • opdateret af anonymous 9 år siden • 3
Have the ability to select multiple tables (already done) and then click the SQL button which generates only the tables and their related objects.


Kundesupport af UserEcho