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

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]https://www.postgresql.org/docs/current/sql-createtable.html 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

Thanks a lot for your clarification,David.

joe.zhou@dualhelios.com

From: David Rowley
Date: 2024-05-14 15:58
To: 周志勤
CC: pgsql-bugs
Subject: Re: Clarification needed: create partition table can be in another schema other than that of the parent table
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]https://www.postgresql.org/docs/current/sql-createtable.html 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