time_bucket function name clash between timescaleDb and pg_duckdb v1.0.0

[sambitesh]

What happens?

pg_dickdb v1.0.0 added a time_bucket function. TimescaleDB already has this function. So when installing the latest pg_duckdb extension in a server that already has timescaleDB extension leads to error

function time_bucket already exists with same argument types

To Reproduce

CREATE EXTESNION timescaledb;
CREATE EXTENSION pg_duckdb;

OS:

Linux x86_64

pg_duckdb Version (if built from source use commit hash):

v1.0.0

Postgres Version (if built from source use commit hash):

13, 14, 15, 16, 17

Hardware:

No response

Full Name:

Sambitesh Dash

Affiliation:

Microsoft

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• [x] Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• [x] Yes, I have

[JelteF]

Hmm, that should have been fixed by: https://github.com/duckdb/pg_duckdb/pull/747

Are you sure you are installing them in that order? i.e. timescale first and then pg_duckdb