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

  1. Forum: Vertabelo
0

Make column recognition in view work if referencing a manually defined schema

Raphael Mitsch vor 8 Jahren • aktualisiert von Adam Mościcki vor 8 Jahren • 1

Can't get column recognition to work if a insert a SQL query in a view's SQL field and refer to tables or views in other schemas. E.g.: If a insert this query in a view's SQL field, the columns get recognized automatically -

select id from some_table

- but if I do this, the parser shows an error message:

select id from some_schema.some_table

Even though some_table has "some_schema" set as it's schema.


Is there a way to get this to work or is it simply a bug/only partly implemented feature?

Antwort
Adam Mościcki vor 8 Jahren

Hello,


Sorry for a late response. We have missed that one.

I think it is a partially implemented feature and works only for `schemaless` views.


Best regards,

Adam Mościcki

0

Team name

Norbert Pabiś vor 8 Jahren • 0

I am a member of different teams. I would welcome a feature when I can give a name or nickname to the team. The name can then be shown in top, black bar between label Halp and user icon. That would help me to see current team.

0
Fertiggestellt

Como hago para anotarme como estudiante, cuando ya cree en la cuenta?

Florencia Wilgenhoff vor 8 Jahren • aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren • 1
0
Beantwortet

User died. Need to re-assign ownership's and delete account

Dean Martin vor 8 Jahren • aktualisiert von anonymous vor 8 Jahren • 2

User died, was owner of a document. Need to delete document he owned (already copied to new owner) and delete his account so we can add a new user (we are at our max user limit). I can't seem to do anything as administrator but lock his account.

0
Beantwortet

Account missing

imrankhanamardan vor 8 Jahren • aktualisiert von anonymous vor 8 Jahren • 2

I had an account with email: imrankhanamardan@gmail.com. Now when I enter my credentials it says "We don't have an account with the email address you have provided." Can someone please help me with that?

0

You've been copied

noemail vor 8 Jahren • 0

Watch out guys, Erwin team had a discussion and trying to copy your UI.

0
Not a bug

Joining a team cancelled my Prenium acount

Stéphan Doucet vor 8 Jahren • aktualisiert von anonymous vor 8 Jahren • 1

I was recently added to a team because someone wanted to share a database model with me. But by joining the team, this cancelled my prenium account. I want to go back to my prenium account and leave the team. How can I do this?

0
Fertiggestellt

Duplicate a Table

Rafi Galibov vor 8 Jahren • aktualisiert vor 8 Jahren • 2

It would be really handy to have an option to 'duplicate' a table on a diagram when you are trying to create a table with a very similar set of columns. Possibly add it to drop down menu when you choose a Model/Table and have it append '_copy' to duplicated table name.

0
Geplant

Add missing postgresql column types

Andrew Smith vor 9 Jahren • aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren • 5

Trying to import an existing DB structure from PostgreSQL and the importer says that a number of columns are unsupported. Currently I've found TIMESTAMPTZ and TSTZRANGE (and it looks like none of the range types are recognised).


TIMESTAMPTZ seems to work within the editor, but trying to import from an SQL file that includes a column of that type fails and the rest of the table definition is ignored.



Customer support service by UserEcho