Latest commit gives an catalog error (while running phoenix-analytics)

[Terbium-135]

while running phoenix-analytics , which depends on duckdbex, I get following error since commit 2eacc62

Catalog Error: Scalar Function with name "get_current_timestamp" is not in the catalog, but it exists in the core_functions extension.

Please try installing and loading the core_functions extension by running:
INSTALL core_functions;
LOAD core_functions;

Alternatively, consider enabling auto-install and auto-load by running:
SET autoinstall_known_extensions=1;
SET autoload_known_extensions=1;

[AlexR2D2]

DuckDB dev team move some core functions to core_functions extension.

You need to install this extension

{:ok, db} = Duckdbex.open("analytics.duckdb")
{:ok, conn} = Duckdbex.connection(db)
{:ok, _} = Duckdbex.query(conn,  "INSTALL core_functions;")
{:ok, _} = Duckdbex.query(conn,  "LOAD core_functions;")

Alternatively, consider enabling auto-install and auto-load by running:

{:ok, _} = Duckdbex.query(conn,  "SET autoinstall_known_extensions=1;")
{:ok, _} = Duckdbex.query(conn,  "SET autoload_known_extensions=1;")

I think you need to forward this issue to phoenix-analytics, so that they install this extension automatically for your.
As workaround you can try to open you DB "analytics.duckdb" and run the queries to instal extension by yourself.

[Terbium-135]

Thanks a lot for the quick response!
Will forward.

[dantodor]

For the record, I tried that, but at lest on my Mac it says that it can't find the extension. And also setting to autoinstall and autoload does nothing, probably because the same reason. ATM, I'll just use 0.3.7

[AlexR2D2]

@dantodor by the way is your Mac on Intel chipset?

[dantodor]

M2, MacBook Pro

[dantodor]

OK, my mistake. I was using duckdb 1.1.3 and issuing the load and install commands. After upgrading, it works.