cortezaproject / corteza

Low-code platform
https://cortezaproject.org
Apache License 2.0
1.64k stars 375 forks source link

Error using POSTGRESQL schema #1870

Open alrikvidal opened 3 months ago

alrikvidal commented 3 months ago

Is there an existing issue for this?

Version of Corteza

2023.9.7

Current Behavior

Hello,

When I add a PostgreSQL connection with a schema to the DSN like this:

{ "dsn": "postgres://USER:%PASSWORD@IP/DATABASE?sslmode=require&search_path=SCHEMA" }

the connection works fine. When I create a module and select this connection, Corteza creates the table with the correct columns. However, I receive the following error message: "Cannot search data entry: cannot perform record operation."

If I go back to the module, I see: "Schema alterations ==> Add schema for model suivistt_lapin_records." If I try to resolve this, the message persists.

Any ideas?

Expected Behavior

No response

Steps To Reproduce

No response

Environment and versions

No response

Anything else?

No response

github-actions[bot] commented 3 days ago

Stale issue message