Skip to content

Add support for partition tables in Postgresql #34329

@twosoy

Description

@twosoy

When using SINGLE Table config,Add support for partition tables in Postgresql

1.ShardingSphere Version:5.5.1

image

2.postgresql version: 11.22

image

3.SQL is : “SELECT * FROM SYS_LOG” AND Exception Occur "Table or view 'SYS_LOG' does not exist“

image

4.config.yaml - SINGLE Table config

image

5.Cause Analysis:

(1)The table "SYS_LOG" is PARTITIONED TABLE

image

(2)ShardingSphereTable not contain PARTITIONED TABLES

image

(3)SchemaMetaDataLoader just load type in (TABLE_TYPE, VIEW_TYPE, SYSTEM_TABLE_TYPE, SYSTEM_VIEW_TYPE)

image image

6.Suggested solution:SchemaMetaDataLoader Add ”PARTITIONED TABLE“ Type

postgresql PARTITIONED TABLE

image

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions