RE: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian

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

In response to

Responses

Browse pgsql-hackers by date

  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