Postgres Pro
Downloads
Home   >   mailing lists

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

From 周志勤
Subject Clarification needed: create partition table can be in another schema other than that of the parent table
Date
Msg-id 048B376714E008E5+202405141544517974659@dualhelios.com
Whole thread Raw
Responses Re: Clarification needed: create partition table can be in another schema other than that of the parent table
List pgsql-bugs
Tree view
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.zhou@dualhelios.com

pgsql-bugs by date:

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