Re: unexpected relkind: 73 ERROR with partition table index
Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
From: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-06-27T05:59:45Z
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@2ndquadrant.com> wrote: > On 2018-Jun-27, David Rowley wrote: > > > On 27 June 2018 at 00:18, Rajkumar Raghuwanshi > > <rajkumar.raghuwanshi@enterprisedb.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 >
Commits
-
Enable failure to rename a partitioned index
- 040da42367a5 11.0 landed