Re: pgAdmin can't create Expression Indexes

Yes, this doesn't affect me, but it just seems to be the wrong workflow,
but if you guys don't get annoyed about it, then it's fine I guess.

On Wed, May 15, 2019, 09:27 Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> On Wed, May 15, 2019 at 1:01 PM Michel Feinstein <
> michelfeinstein(at)gmail(dot)com> wrote:
>
>> Well, I did a quick look at it and I could see it indeed has more
>> options... But for external people (like me) it seems more complicated to
>> file Issues and keep track of them.
>>
>> On Github I would open the project's page, open a new issue, and every
>> time there is a new message for my issue (and only my issue) I will be
>> notified by email. If anyone wants to know what we spoke about it, all the
>> thread is right there on the Issue page.
>>
>> But currently if I want to file a bug or a feature I have to enroll to an
>> email list to communicate it, so I will receive messages for everything,
>> every day, which is not in my interest, so I will unsubscribe from this
>> mailing list and stop receiving messages for everything, including the only
>> think I care about. If I want to check what was argued about an issue in
>> the past, I have to search into several emails, not as clean as an Issue
>> thread.
>>
>
> Not according to the website: https://www.pgadmin.org/support/
>
>
>
>> Also, I didn't have to login to file a bug report, I could set the
>> priority, assign it to people, I had apparently lots of control over it.
>>
>
> I'm not sure how that's an issue? It's mildly annoying for us when people
> set the priority of a typo fix to "Immediate", assign it to a developer and
> set the target version, but that shouldn't affect you - and you don't have
> to fill in those details.
>
>
>
>> Not even to mention the interface seems bulky and outdated (but this is
>> minor aesthetics, so I don't take this seriously).
>>
>
> I'll take functionality and fitness for purpose over pretty any day :-)
>
>
>>
>> Github Issues aren't as complete, but I think it has enough, you can set
>> it to a milestone, label it, assign it to people, automatically close it
>> with a commit and a pull request, easy to see, follow and track what's
>> related to it... All of it with user access control, on who can do what...
>> But if your current system has more stuff and you like it, it's fine, it's
>> just gave me the appearance of being clunkier, and definitely not as easy
>> for someone from outside of the project to jump-in, report, jump-out and
>> get eventual updates.
>>
>> Best wishes,
>>
>> Michel.
>>
>>
>>
>> On Wed, May 15, 2019, 05:31 Ray O'Donnell <ray(at)rodonnell(dot)ie> wrote:
>>
>>> On 15 May 2019 06:59:11 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? - Just curious.
>>>
>>> Ray.
>>>
>>>
>>>
>>>
>>>
>>>
>>>>
>>>> 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
>