Horton

Re: MERGE/SPLIT partition commands should create new partitions in the parent's tablespace?

Fujii Masao <masao.fujii@oss.nttdata.com>

View thread View on postgr.es
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2024-07-15T05:00:29Z
Lists: pgsql-hackers

Attachments


On 2024/07/15 13:33, Fujii Masao wrote:
> 
> 
> On 2024/07/12 21:17, Masahiko Sawada wrote:
>> On Thu, Jul 11, 2024 at 8:14 PM Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
>>>
>>>
>>>
>>> On 2024/07/10 22:35, Masahiko Sawada wrote:
>>>> BTW the new regression tests don't check the table and index names.
>>>> Isn't it better to show table and index names for better
>>>> diagnosability?
>>>
>>> Sounds good to me. I've updated the patch as suggested.
>>> Please see the attached patch.
>>>
>>
>> Thank you for updating the patch! LGTM.
> 
> Thanks for reviewing the patch! I've pushed it.
> 
> However, some buildfarm members reported errors, so I'll investigate further.

Attached patch fixes unstable tests. Currently testing before pushing.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Commits

  1. Fix unstable tests in partition_merge.sql and partition_split.sql.

  2. Fix tablespace handling in MERGE/SPLIT partition commands.