Re: Indexing on JSONB field not working

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Zhihong Zhang <zhihong(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Indexing on JSONB field not working
Date: 2019-12-27 02:30:59
Message-ID: 20191227023059.gsvib26ufgpjbwky@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Dec 26, 2019 at 06:57:52PM -0500, Zhihong Zhang wrote:
>I created the index myself using the same account. Should I be the owner?
>

But Tom explicitly said "owner of the index's table" so it's not
important who created the index. But it's easy to check the owner of
tables (e.g. using \d+ in psql).

BTW please reply in-line (instead of top-posting), it's easier to follow
the discussion that way.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message vignesh C 2019-12-27 08:20:15 Re: Reorderbuffer crash during recovery
Previous Message Zhihong Zhang 2019-12-26 23:57:52 Re: Indexing on JSONB field not working