Hi,
I should post that in the general section but I am confused by the sentence "A parent partition is always going to have a lower relid than its children" In the code, relid has many meanings and not only "oid of a class" as in https://www.postgresql.org/message-id/20910.1111734...@sss.pgh.pa.us ? PostgreSQL: Re: relid and relname<https://www.postgresql.org/message-id/20910.1111734...@sss.pgh.pa.us> www.postgresql.org Michael Fuhr <mike(at)fuhr(dot)org> writes: > On Thu, Mar 24, 2005 at 11:01:23PM -0300, Edson Vilhena de Carvalho wrote: >> Can anyone tell me what is a relid, a relname and In fact, I want to be sure I can say to the developers they will always be able to create tables and partitions in any order : create table child1(c1 int, c2 int); create table midparent1(c1 int, c2 int) partition by list(c2); alter table midparent1 attach partition child1 for values in (1); create table child2 partition of midparent1 for values in (2); create table topparent(c1 int, c2 int) partition by list(c1); alter table topparent attach partition midparent1 for values in (1); select relname, relkind, oid from pg_class where relname in ('topparent', 'midparent1', 'child1', 'child2') order by oid asc; relname | relkind | oid ------------+---------+-------- child1 | r | 123989 midparent1 | p | 123992 child2 | r | 123995 topparent | p | 123998 (4 lignes) Regards Phil
