From: | 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> |
---|---|
To: | "David Rowley" <dgrowleyml(at)gmail(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Re: Clarification needed: create partition table can be in another schema other than that of the parent table |
Date: | 2024-05-14 08:08:42 |
Message-ID: | 91680E368415A071+2024051416074094235311@dualhelios.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thanks a lot for your clarification,David.
joe(dot)zhou(at)dualhelios(dot)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(dot)zhou(at)dualhelios(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | 周志勤 | 2024-05-14 08:09:24 | Re: Re: Clarification needed: create partition table can be in another schema other than that of the parent table |
Previous Message | Kashif Zeeshan | 2024-05-14 07:59:59 | Re: Clarification needed: create partition table can be in another schema other than that of the parent table |