Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Child tables are not dispayed #6

Closed
glushakov opened this issue May 6, 2020 · 3 comments
Closed

Child tables are not dispayed #6

glushakov opened this issue May 6, 2020 · 3 comments

Comments

@glushakov
Copy link

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
Copy link
Owner

levinsv commented May 7, 2020

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
Copy link
Author

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
Copy link
Author

with declarative partitioning the situation is similar

levinsv added a commit that referenced this issue May 8, 2020
@levinsv levinsv closed this as completed May 8, 2020
@tobwen tobwen mentioned this issue Sep 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants