Home > mailing lists

Re: Add SPLIT PARTITION/MERGE PARTITIONS commands - Mailing list pgsql-hackers

From	Alexander Korotkov
Subject	Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date	May 13 13:37:31
Msg-id	CAPpHfdsw9Wb5mCpULhEG=ouA3d7Rp5zGw=159dFs_5uGz+ftXw@mail.gmail.com Whole thread Raw
In response to	Re: Add SPLIT PARTITION/MERGE PARTITIONS commands (Dmitry Koval <d.koval@postgrespro.ru>)
List	pgsql-hackers

Tree view

On Mon, May 13, 2024 at 12:45 PM Dmitry Koval <d.koval@postgrespro.ru> wrote:
> 13.05.2024 11:45, Daniel Gustafsson пишет:
> > Commit 3ca43dbbb67f which adds the permission checks seems to cause conflicts
> > in the pg_upgrade tests
>
> Thanks!
>
> It will probably be enough to rename the roles:
>
> regress_partition_merge_alice -> regress_partition_split_alice
> regress_partition_merge_bob -> regress_partition_split_bob

Thanks to Danial for spotting this.
Thanks to Dmitry for the proposed fix.

The actual problem appears to be a bit more complex.  Additionally to
the role names, the lack of permissions on schemas lead to creation of
tables in public schema and potential conflict there.  Fixed in
2a679ae94e.

------
Regards,
Alexander Korotkov

pgsql-hackers by date:

From: Aleksander Alekseev
Date: 13 May, 13:22:22
Subject: Re: [PATCH] Replace magic constant 3 with NUM_MERGE_MATCH_KINDS

From: Nazir Bilal Yavuz
Date: 13 May, 13:57:08
Subject: Upgrade Debian CI images to Bookworm

Re: Add SPLIT PARTITION/MERGE PARTITIONS commands - Mailing list pgsql-hackers

Previous

Next