Home > mailing lists

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

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

From

周志勤

Date:

14 May, 10:45:52

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

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

From

David Rowley

Date:

14 May, 10:58:00

On Tue, 14 May 2024 at 19:46, 周志勤 <joe.zhou@dualhelios.com> wrote:
> 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?

This is working as intended.  The behaviour is documented in [1] with
"If a schema name is given (for example, CREATE TABLE myschema.mytable
...) then the table is created in the specified schema."

David

[1] https://www.postgresql.org/docs/current/sql-createtable.html