Re: Clarification needed: create partition table can be in another schema other than that of the parent table

Hi

It's not a bug.

Regards
Kashif Zeeshan
Bitnine Global

On Tue, May 14, 2024 at 12:50 PM 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> wrote:

> Loop in pgsql-bugs-owner.
>
> ------------------------------
> joe(dot)zhou(at)dualhelios(dot)com
>
>
> *发件人：* 周志勤 <joe(dot)zhou(at)dualhelios(dot)com>
> *发送时间：* 2024-05-14 15:45
> *收件人：* pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
> *主题：* 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.
>
> Looking forward to your reply.
>
> Thanks and best regards,
> Joe
>
> ------------------------------
> joe(dot)zhou(at)dualhelios(dot)com
>
>