| From: | Phil Florent <philflorent(at)hotmail(dot)com> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian |
| Date: | 2018-07-16 04:56:41 |
| Message-ID: | DB7PR03MB47306F095D2E0BFA4B2D140CBA5D0@DB7PR03MB4730.eurprd03.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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://stream.boxwatch.ru/message-id/20910.1111734343@sss.pgh.pa.us ?
PostgreSQL: Re: relid and relname<https://stream.boxwatch.ru/message-id/20910.1111734343@sss.pgh.pa.us>
stream.boxwatch.ru
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-07-16 05:48:54 | Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian |
| Previous Message | David Rowley | 2018-07-16 04:27:18 | Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian |