citusdata / citusdata/citus

Altering existing database objects (e.g., oid < FirstNormalObjectId) is not propagated, which causes issues

Open
#5,850 0 comments 0 reactions 0 assignees View on GitHub
dev_reported
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

```SQL
CREATE SCHEMA sc10;
alter function generate_series_int4_support set schema sc10;

CREATE FUNCTION public.func_with_support_2(int, int) RETURNS bool
LANGUAGE internal STRICT IMMUTABLE PARALLEL SAFE
AS $$int4eq$$;

ALTER FUNCTION public.func_with_support_2(int, int) SUPPORT sc10.generate_series_int4_support;
ERROR: function sc10.generate_series_int4_support(internal) does not exist
CONTEXT: while executing command on localhost:9701
```

The workarounds is to;
```SQL
select run_command_on_workers($$alter function generate_series_int4_support set schema sc10;$$);
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.