Re: pgAdmin can't create Expression Indexes

On Wed, May 15, 2019 at 6:59 AM Michel Feinstein <michelfeinstein(at)gmail(dot)com>
wrote:

> I will...but just to add my 2 cents, it would be a lot better if you guys
> could move to Github and use their Issue system instead.
>

Why is that? There are various features we use daily to manage our backlog
that it doesn't have - not to mention that we very intentionally run all
our own software and servers so we have full control over the data and
environment.

>
> On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <
>> michelfeinstein(at)gmail(dot)com> wrote:
>>
>>> I can't find a way to create an Expression Index such as:
>>>
>> Yes, it's not there. You can raise a feature request here -
>> https://redmine.postgresql.org/projects/pgadmin4/issues
>>
>>>
>>> CREATE UNIQUE INDEX idx_lower_unique
>>> ON your_table (lower(the_column));
>>>
>>> Am I missing something or does pgAdmin really doesn't support it?
>>>
>>> Best wishes,
>>>
>>> Michel.
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company