citusdata / citusdata/cstore_fdw

Renaming public schema breaks cstore

Open
#211 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.8k
Forks
169
PR merge metrics
No merged PRs in 30d

Description

If we rename public schema then hardcoded function calls won't work, so cstore tables can't be dropped. I think this is not the intended behaviour either. See #125 for reference.

```
dev=# drop foreign table public.gen_releases;
ERROR: function public.cstore_clean_table_resources(oid) does not exist
LINE 1: SELECT public.cstore_clean_table_resources(v_obj.objid)
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT public.cstore_clean_table_resources(v_obj.objid)
CONTEXT: PL/pgSQL function public_20190402_18.cstore_drop_trigger() line 10 at PERFORM
```

I tried to create a new cstore_server with different name but that didn't create the functions in public. Looks like I'd have to create these functions in public or move them back to public manually for all the functions.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.