主题: Clarification needed: create partition table can be in another schema other than that of the parent table
Hi Pgsql bugs,
I have the following scenario:
ptable sits in schema:BBB
create table AAA.ptable18250w partition of BBB.ptable for values from (180000000) to (182500000);
Now the ptable has a partition table: ptable18250w sits in schema AAA.
Is this what we intent to do or an issue? as we do a sql search under schema BBB, we will never find this table,which causes a lot of confusion for me.