Обсуждение: 回复: Clarification needed: create partition table can be in another schema other than that of the parent table
Loop in pgsql-bugs-owner.
joe.zhou@dualhelios.com
发件人: 周志勤发送时间: 2024-05-14 15:45收件人: pgsql-bugs主题: Clarification needed: create partition table can be in another schema other than that of the parent tableHi Pgsql bugs,I have the following scenario:ptable sits in schema:BBBcreate 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.Looking forward to your reply.Thanks and best regards,Joejoe.zhou@dualhelios.com
Hi
It's not a bug.
Regards
Kashif Zeeshan
Bitnine Global
On Tue, May 14, 2024 at 12:50 PM 周志勤 <joe.zhou@dualhelios.com> wrote:
Loop in pgsql-bugs-owner.发件人: 周志勤发送时间: 2024-05-14 15:45收件人: pgsql-bugs主题: Clarification needed: create partition table can be in another schema other than that of the parent tableHi Pgsql bugs,I have the following scenario:ptable sits in schema:BBBcreate 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.Looking forward to your reply.Thanks and best regards,Joe