Re: unexpected relkind: 73 ERROR with partition table index

From: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: unexpected relkind: 73 ERROR with partition table index
Date: 2018-06-27 05:59:45
Message-ID: CAKcux6mhFWp-XT6BZOUQ4=r8yORAA-J+MOCFNm76eidDmSL_dw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks for fix and commit. It is working fine now.

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

On Tue, Jun 26, 2018 at 8:39 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

> On 2018-Jun-27, David Rowley wrote:
>
> > On 27 June 2018 at 00:18, Rajkumar Raghuwanshi
> > <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> wrote:
> > > postgres=> ALTER INDEX part_idx RENAME TO part_idx_renamed;
> > > ERROR: unexpected relkind: 73
> >
> > Seems to be caused by the auth failure code path in
> > RangeVarCallbackForAlterRelation().
>
> Ah, yeah, thanks. No surprise this was missed, since I didn't add
> tests for ALTER INDEX RENAME and Peter concurrently refactored the
> handling code. I propose we add a few more test lines, as attached.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2018-06-27 06:00:13 Re: Thinko/typo in ExecSimpleRelationInsert
Previous Message Andres Freund 2018-06-27 05:55:58 Re: partitioning - changing a slot's descriptor is expensive