Re: Issue in pg_catalog.pg_indexes view definition

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Issue in pg_catalog.pg_indexes view definition
Date: 2016-07-14 08:29:37
Message-ID: CAFiTN-sdp31upXTMrfOWgbsftmhT5Zbp681T4KBRkB4E7D_G4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 14, 2016 at 1:40 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> - pg_get_indexdef(I.oid) AS indexdef
> + pg_get_indexdef(X.indexrelid) AS indexdef
> Fixing it this way looks like a good idea to me to bypass those cache
> lookup errors caused by non-index relations. Now I think that you need
> as well to update the regression test output.
>

I observed one regression failure caused by this fix. So fixed the same in
new patch.

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Attachment Content-Type Size
pg_indexes_fix_v1.patch application/octet-stream 1.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message AMatveev 2016-07-14 08:41:07 Re: One process per session lack of sharing
Previous Message Dilip Kumar 2016-07-14 08:21:14 Re: Issue in pg_catalog.pg_indexes view definition