Changes by alsenchenko:

• added labels: postgres

Michael Bayer (@zzzeek) wrote:

please read the bug reporting guidelines and reopen with the correct format, thanks!

Changes by Michael Bayer (@zzzeek):

• changed status to closed

Michael Bayer (@zzzeek) wrote:

example:

dv = Table(
    'data_values', metadata,
    Column('modulus', Integer, nullable=False),
    Column('data', String(30)),
    postgresql_partition_by='range(modulus)')

from sqlalchemy import event, DDL

event.listen(
    dv,
    "after_create",
    DDL("CREATE TABLE data_values_4_10 PARTITION OF data_values "
        "FOR VALUES FROM (4) TO (10)")
)

# ... after the create

dv = Table("data_values", m, autoload_with=testing.db)

print(CreateTable(dv))

CREATE TABLE data_values (
	modulus INTEGER NOT NULL, 
	data VARCHAR(30)
)

two problems: 1. we aren't getting the partition_by expression and 2. we can't reflect data_values_4_10. We need at least a solution for #1

Changes by Michael Bayer (@zzzeek):

• changed status to reopened

Changes by Michael Bayer (@zzzeek):

• removed labels: bug
• added labels: feature

Changes by Michael Bayer (@zzzeek):

• changed title from "Couldn't reflect postgres table. PG 10" to "support reflection of PG 10 partitioned tables"

Changes by Michael Bayer (@zzzeek):

• set milestone to "1.3"

Michael Bayer (@zzzeek) wrote:

https://gerrit.sqlalchemy.org/#/c/zzzeek/sqlalchemy/+/888

Michael Bayer (@zzzeek) wrote:

Add reflection support for Postgresql partitioned tables

Added rudimental support for reflection of Postgresql
partitioned tables, e.g. that relkind='p' is added to reflection
queries that return table information.

Fixes: #4237
Change-Id: I66fd10b002e4ed21ea13b13a7e35a85f66bdea75

→ f1ca155

Changes by Michael Bayer (@zzzeek):

• changed status to closed