Database connection error in dbeaver

[e20999]

When I create a new database connection in dbeaver, I receive an error message:
(base) C:\Users\thinkpad>python -m buenavista.examples.duckdb_postgres D:\abc.db
Using DuckDB database at D:\abc.db
Listening on 0.0.0.0:5433
Catalog Error: Type with name REGCLASS does not exist!
Did you mean "real"?
Catalog Error: Table Function with name pg_get_keywords does not exist!
Did you mean "main.duckdb_keywords"?
LINE 1: SELECT GROUP_CONCAT(word, ',') FROM pg_catalog.PG_GET_KEYWORDS() WHERE word...
^
Catalog Error: Type with name REGCLASS does not exist!
Did you mean "real"?

Please explain why this is and how it needs to be resolved? Thank you.

[Mause]

This sounds like an issue in Buenavista, not DuckDB

[jwills]

Indeed it's an issue with Buenavista-- we hack some of the postgres catalog to make it work with DuckDB, but there is still plenty of stuff that different clients want that is missing-- e.g., the regclass types. I unfortunately do not have time right now to add it in, so I'm just going to post a note that Buena Vista can be used with e.g. psql and leave it at that.

[e20999]

How can I establish a connection correctly in dbeaver now?

[e20999]

Using navicat also fails to connect properly, with the following error prompt:
Binder Error: Referenced column "datlastsysoid" not found in FROM clause!
Candidate bindings: "pg_database.oid"
LINE 1: SELECT DISTINCT datlastsysoid FROM pg_database
^
Binder Error: Referenced column "datlastsysoid" not found in FROM clause!
Candidate bindings: "pg_database.oid"
LINE 1: SELECT DISTINCT datlastsysoid FROM pg_database

[e20999]

This sounds like an issue in Buenavista, not DuckDB

yes,thank you

[rzykov]

@e20999 d99f8fc
fix that