citusdata / citusdata/citus

Alter table udfs ignore rules on tables

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

Description

```sql
CREATE TABLE dist_table_1 (id int, test text);
SELECT create_distributed_table('dist_table_1', 'id');

CREATE OR REPLACE RULE dist_table_1 AS
ON DELETE TO dist_table_1 DO NOTHING;

\d+ dist_table_1
Table "public.dist_table_1"
┌────────┬─────────┬───────────┬──────────┬─────────┬──────────┬─────────────┬──────────────┬─────────────┐
│ Column │ Type │ Collation │ Nullable │ Default │ Storage │ Compression │ Stats target │ Description │
├────────┼─────────┼───────────┼──────────┼─────────┼──────────┼─────────────┼──────────────┼─────────────┤
│ id │ integer │ │ │ │ plain │ │ │ │
│ test │ text │ │ │ │ extended │ │ │ │
└────────┴─────────┴───────────┴──────────┴─────────┴──────────┴─────────────┴──────────────┴─────────────┘
Rules:
dist_table_1 AS
ON DELETE TO dist_table_1 DO NOTHING
Access method: heap

select undistribute_table('dist_table_1');

\d+ dist_table_1
Table "public.dist_table_1"
┌────────┬─────────┬───────────┬──────────┬─────────┬──────────┬─────────────┬──────────────┬─────────────┐
│ Column │ Type │ Collation │ Nullable │ Default │ Storage │ Compression │ Stats target │ Description │
├────────┼─────────┼───────────┼──────────┼─────────┼──────────┼─────────────┼──────────────┼─────────────┤
│ id │ integer │ │ │ │ plain │ │ │ │
│ test │ text │ │ │ │ extended │ │ │ │
└────────┴─────────┴───────────┴──────────┴─────────┴──────────┴─────────────┴──────────────┴─────────────┘
Access method: heap
```

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.