Postgres Pro
Downloads
Home   >   mailing lists

Re: Clarification needed: create partition table can be in another schema other than that of the parent table - Mailing list pgsql-bugs

From Kashif Zeeshan
Subject Re: Clarification needed: create partition table can be in another schema other than that of the parent table
Date
Msg-id CAAPsdhfXKnA5ZsdQ8Kd1mtK5JLEngJa5+JQF+OYfkkCNf_50FA@mail.gmail.com
Whole thread Raw
In response to 回复: Clarification needed: create partition table can be in another schema other than that of the parent table  (周志勤 <joe.zhou@dualhelios.com>)
List pgsql-bugs
Tree view
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 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

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: Clarification needed: create partition table can be in another schema other than that of the parent table
Next
From: 周志勤
Date:
Subject: Re: Re: Clarification needed: create partition table can be in another schema other than that of the parent table