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

0
À l'étude

Remove watermark

Denise Herne il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 1

I have the licence for vertabelo but still, when I generate my png it is showing watermark . how to remove that?

0
À l'étude

login doesn't works

Vitoria Turina il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 1

Hi, I've made a login in Vertabelo with my e-mail account, event bought the SQL complete course and made some lessons, but now, when I tried to login again, the plataform says that my user doesn't exist. Can someone plese, help me? 

Thanks, 

0
À l'étude

Support for Postgres array data types

Phil Constantinou il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 1

How should I handle array data types from Postgres 9.2 in Vertabelo. 

- Can I declare them visually?

- Can I create indexes on them?

- If not, is there a workaround.

+6
À l'étude

Triggers

mark leavesley il y a 10 ans mis à jour par Chad P. Prince il y a 6 ans 2
I've seen the workaround to add computed columns but it doesn't show graphically that the column is computed. Likewise, I could do the same for triggers but again I wouldn't be able to see at a glance where the triggers were. I would have thought another box like you have for default value etc would suffice. If you don't want to make an interface to build triggers fine, but at least allow us to mark that a column has update/insert/delete triggers or is computed.
0
Corrigé

Postgres migration does not specify schema in DROP INDEX command

Chase Roden il y a 6 ans mis à jour il y a 6 ans 5

When I generate a migration that modifies an index in Postgres, the generated SQL does not specify the schema for the index on the DROP statement and therefore fails. In this example I changed WHERE clause on an index:


Image 743

The resulting DROP INDEX command does not work unless the schema is specified:

Image 745
0
Prévu

Postgres: Access method "gin" does not support ASC/DESC options

Chase Roden il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 1

When I create an index that uses the GIN access method, Vertabelo requires me to choose ASC or DESC:

Image 739

-- which GIN does not support. So the generated SQL DDL says (e.g.):

CREATE INDEX test_table_idx_1 on schema.test_table USING gin (column_2 ASC);

If I don't manually remove the "ASC" from generated code, Postgres will not run the statement, returning

access method "gin" does not support ASC/DESC options

I would like to be able to unset the ASC/DESC option and have the generated SQL not include the index order when it's not compatible with the access method, so that the generated SQL looks like:

CREATE INDEX test_table_idx_1 on schema.test_table USING gin (column_2);

+2

Add option for PRIMARY KEY that is NONCLUSTERED

Dixant Rai il y a 6 ans 0

Users should be able to create PrimaryKey tha is NONCLUSTERED. While PK flag to identify them the default should be CLUSTERED (as is the case in most RDMSs) but an option should be available to be able to create a NONCLUSTERED one as well. The resultant DDL script should result in this.

CREATE TABLE sample_table (
   sample_column int  NOT NULL,
   CONSTRAINT sample_table_pk PRIMARY KEY NONCLUSTERED (sample_column)
);
0
À l'étude

NONCLUSTERED PRIMARY KEY

Dixant Rai il y a 6 ans mis à jour il y a 6 ans 5

Is it possible to create NONCLUSTERED PrimaryKey while still using the PK flag to identify them? I'm trying to achieve this in sql server.

0
À l'étude

why should i upgrade my account if i am a student?

Natalia Górecka il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 2

I heard that being a student helps you to have more upgraded account than normal user. Though, i cannot do more references because it says i dont have upgraded my account. Could anyone tell me why is like that? I have a project to do for my university programme and they asured me it will be free and upgraded.