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

From: 周志勤 <joe(dot)zhou(at)dualhelios(dot)com>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Clarification needed: create partition table can be in another schema other than that of the parent table
Date: 2024-05-14 07:45:52
Message-ID: 048B376714E008E5+202405141544517974659@dualhelios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 周志勤 2024-05-14 07:50:13 回复: Clarification needed: create partition table can be in another schema other than that of the parent table
Previous Message Ugur Yilmaz 2024-05-14 07:40:41 Ynt: Postgresql 16.3 installation error (setup file) on Windows 11