Export tables without roles? about pgmodeler HOT 3 OPEN

Hi @tachoknight

I've been trying to export a database design with a user that has the create table role, but it seems pgModeler when doing its validation is trying to create a role with it, but that is utterly unnecessary and the user does not have that particular role,

In that case, disable the SQL code of the role (or any other object) that isn't necessary. You can achieve that by opening the role's editing form and checking "Disable SQL code", then applying.

so it doesn't work (and exporting directly to the database leads to the app crashing).

Are you on macOS? If so, recently, pgModeler started to crash on that OS. I already know the cause and I am already in the process of patching it. The crash happens when pgModeler raises an exception, and due to internal mechanisms of the Qt framework, the exception is leaking and never being caught. The solution is kind of simple but it'll take some time to get concluded. Unfortunately.

from pgmodeler.

In that case, disable the SQL code of the role (or any other object) that isn't necessary. You can achieve that by opening the role's editing form and checking "Disable SQL code", then applying.

Is that done in the "Model Objects" pane, to the right of the Design window?

Are you on macOS? If so, recently, pgModeler started to crash on that OS. I already know the cause and I am already in the process of patching it. The crash happens when pgModeler raises an exception, and due to internal mechanisms of the Qt framework, the exception is leaking and never being caught. The solution is kind of simple but it'll take some time to get concluded. Unfortunately.

Yep, this is 1.10 on macOS with QT 6.6.1

from pgmodeler.

In that case, disable the SQL code of the role (or any other object) that isn
Is that done in the "Model Objects" pane, to the right of the Design window?

Yes, if you double-click the role from there it'll open the window where that option I've mentioned can be found.

If you right click the role, go to Quick > Disable SQL

Yep, this is 1.10 on macOS with QT 6.6.1

Great. If the crashes bother you too much you can switch to Linux or Windows for now until I fix everything. :)

from pgmodeler.