SELECT time_bucket - No function matches the given name

TimescaleDB and PostgreSQL
1

I’m following Creating an aggregate query chapter to setup my db.

I have this error message:

ERROR:  function time_bucket(unknown, unknown) does not exist
LINE 1: select time_bucket('1 day', 'timeseries') from telemetry ;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

when I try to execute this query:

select time_bucket('1 day', 'timeseries') from telemetry ;

I checked this:

CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
NOTICE:  extension "timescaledb" already exists, skipping
CREATE EXTENSION

and this:

=# SELECT DISTINCT routine_name
-# FROM information_schema.routines
WHERE rodispmpf-# WHERE routine_type = 'FUNCTION'
-# AND routine_name = 'time_bucket';
 routine_name
--------------
 time_bucket
(1 row)

and I have no more ideas about how to solve it.

My hypertable creates with

SELECT create_hypertable('timeseries.telemetry', 'timestamp');

My server is actual image: timescale/timescaledb:2.8.1-pg14 with psql client built into this image

2

SOLVED

If you use separated schemas, add your shema name with the public one to the search_path:

set search_path to timeseries,public ;
select time_bucket('1 days', timestamp) from timeseries.telemetry ;