Re: ATTACH PARTITION "hangs"

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: kyle Hailey <kylelf(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: ATTACH PARTITION "hangs"
Date: 2023-05-11 22:14:17
Message-ID: CAMkU=1zbkhU4bE8GLJbmOkrDM4SGdvz5U5_N+U-LMow3Ano+Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 11, 2023 at 3:06 PM kyle Hailey <kylelf(at)gmail(dot)com> wrote:

>
> I created a constraint to make the ATTACH command work immediately
>

You also need to create any indexes which exist on the parent table onto
the incoming partition, otherwise they will need to be created during the
attach operation.

Cheers,

Jeff

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2023-05-11 22:44:37 Re: ATTACH PARTITION "hangs"
Previous Message Ron 2023-05-11 21:23:34 Re: OS rpms needed to support install of postgres 15