[Bug]: permission denied for schema _timescaledb_internal when manually creating index on a continuous aggregate

[feikesteenbergen]

What type of bug is this?

Unexpected error

What subsystems and features are affected?

Continuous aggregate

What happened?

When creating a materialized view as a regular user, the following error is raised when adding an index to a materialized view:

ERROR:  42501: permission denied for schema _timescaledb_internal

TimescaleDB version affected

2.8.0

PostgreSQL version used

14.5

What operating system did you use?

Ubuntu 22.04

What installation method did you use?

Source

What platform did you run on?

On prem/Self-hosted

Relevant log output and stack trace

ERROR:  42501: permission denied for schema _timescaledb_internal
LOCATION:  aclcheck_error, aclchk.c:3447

How can we reproduce the bug?

-- as a regular user, not as a superuser:
CREATE TABLE public.test(inserted timestamptz not null);
SELECT public.create_hypertable('test', 'inserted');
CREATE MATERIALIZED VIEW public.test_cagg WITH (
  timescaledb.continuous,
  timescaledb.materialized_only=false
) AS
SELECT
    public.time_bucket(interval '1 day', inserted) AS bucket,
    count(*) AS n_inserted
FROM
    public.test
GROUP BY
    bucket
WITH NO DATA;

CREATE INDEX ON public.test_cagg(n_inserted);

[jnidzwetzki]

Hello @feikesteenbergen,

Thank you very much for reporting the issue. I could reproduce the problem also with TimescaleDB 2.9.0-dev (b31a015) and PostgreSQL 14.

CREATE USER mytestuser;
GRANT ALL PRIVILEGES ON DATABASE test2 TO mytestuser;
\c test2 mytestuser

CREATE TABLE public.test(inserted timestamptz not null);
SELECT public.create_hypertable('test', 'inserted');
CREATE MATERIALIZED VIEW public.test_cagg WITH (
  timescaledb.continuous,
  timescaledb.materialized_only=false
) AS
SELECT
    public.time_bucket(interval '1 day', inserted) AS bucket,
    count(*) AS n_inserted
FROM
    public.test
GROUP BY
    bucket
WITH NO DATA;

CREATE INDEX ON public.test_cagg(n_inserted);

ERROR:  permission denied for schema _timescaledb_internal