Dropping the schema in which Citus has been created fails if the schema was marked as distributed
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Documenting a probably known/old issue:
```sql
SELECT citus_add_node('localhost', 9701);
-- create a Citus table in public schema to mark public as a distributed object
create table l1 (a int unique);
SELECT create_reference_table('l1');
drop schema public cascade;
NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to extension citus
drop cascades to table l1
ERROR: cache lookup failed for pg_dist_local_group, called too early?
```
Contributor guide
Research direction
Start by running the SQL sequence in the report, including creating the reference table and dropping the public schema. Trace the Citus extension's schema-drop handling when the schema is marked distributed; done means the schema can be dropped without the pg_dist_local_group cache lookup error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases, distributed-systems
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100