Child tables are not dispayed

[glushakov]

Hi. With inherit partititioning, child tables are not display in tree. In parent table (partitions sub menu) there are also not. Checked on pg 10

[levinsv]

Hi. In my test case, everything is Ok.

CREATE TABLE cities (
    name            text,
    population      float,
    altitude        int     -- в футах
);

CREATE TABLE capitals (
    state           char(2)
) INHERITS (cities);

What are your SQL commands?

[glushakov]

it looks like problem appear when child table placed in different schema then parent table. My case:

CREATE TABLE public.history ( itemid bigint NOT NULL, clock integer NOT NULL DEFAULT 0, value numeric(16,4) NOT NULL DEFAULT 0.0000, ns integer NOT NULL DEFAULT 0 );

CREATE TABLE partitions.history_p2020_04_09 (

CONSTRAINT history_p2020_04_09_clock_check CHECK (clock >= 1586379600 AND clock < 1586466000) ) INHERITS (public.history) WITH ( OIDS=FALSE );

[glushakov]

with declarative partitioning the situation is similar