pgAdmin can't create Expression Indexes

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

pgAdmin can't create Expression Indexes

Michel Feinstein
I can't find a way to create an Expression Index such as:

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.
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Aditya Toshniwal
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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"
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Michel Feinstein
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.

On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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"
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Dave Page-7


On Wed, May 15, 2019 at 6:59 AM Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Ray O'Donnell
In reply to this post by Michel Feinstein
On 15 May 2019 06:59:11 Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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"

Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Michel Feinstein
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. 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. Not even to mention the interface seems bulky and outdated (but this is minor aesthetics, so I don't take this seriously). 

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 <[hidden email]> wrote:
On 15 May 2019 06:59:11 Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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"

Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Dave Page-7


On Wed, May 15, 2019 at 1:01 PM Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
On 15 May 2019 06:59:11 Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

mickey
In reply to this post by Michel Feinstein
I'm afraid I agree with this. Also, with my most recent concern, I found that I was posting an issue to the tracker, then responding by email to individuals from the mailing list who offered possible solutions. Some of the potentially useful information ended up in the tracker, but much of it got lost in emails that were more or less private. The record of what did and did not finally solve the problem is scattered about, not in a single place.

2 cents.

>  -------Original Message-------
>  From: Michel Feinstein <[hidden email]>
>  To: Ray O'Donnell <[hidden email]>
>  Cc: Aditya Toshniwal <[hidden email]>, pgadmin-support lists.postgresql.org <[hidden email]>
>  Subject: Re: pgAdmin can't create Expression Indexes
>  Sent: 15 May '19 05:10
>  
>  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. 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. Not even to mention
>  the interface seems bulky and outdated (but this is minor aesthetics,
>  so I don't take this seriously).
>  
>  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 <[hidden email]> wrote:
>  
>  > On 15 May 2019 06:59:11 Michel Feinstein <[hidden email]>
>  > 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
>  > <[hidden email]> wrote:
>  >
>  > Hi,
>  >
>  > On Wed, May 15, 2019 at 7:46 AM Michel Feinstein
>  > <[hidden email]> 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"
>  
>  


Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Dave Page-7


On Wed, May 15, 2019 at 1:54 PM <[hidden email]> wrote:
I'm afraid I agree with this. Also, with my most recent concern, I found that I was posting an issue to the tracker, then responding by email to individuals from the mailing list who offered possible solutions. Some of the potentially useful information ended up in the tracker, but much of it got lost in emails that were more or less private. The record of what did and did not finally solve the problem is scattered about, not in a single place.

Moving to Github issues won't solve that - it would just move one of the places to a privately owned third party site over which we have no control.

We certainly would never want to try to move our primary communications to a tracker either - that would be horrific.
 
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Michel Feinstein
In reply to this post by Dave Page-7
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 <[hidden email]> wrote:


On Wed, May 15, 2019 at 1:01 PM Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
On 15 May 2019 06:59:11 Michel Feinstein <[hidden email]> 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 <[hidden email]> wrote:
Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: pgAdmin can't create Expression Indexes

Michel Feinstein
In reply to this post by Dave Page-7
Well, Github is a private company, but the vast majority of open-source projects are there now, Microsoft owns it and made a statement about it... I can't imagine this changing, it would be a huge PR nightmare for Microsoft. 

I am used to have Stackoverflow for questions and Github for issues, but your workflow here is not bad. 

On Wed, May 15, 2019, 10:02 Dave Page <[hidden email]> wrote:


On Wed, May 15, 2019 at 1:54 PM <[hidden email]> wrote:
I'm afraid I agree with this. Also, with my most recent concern, I found that I was posting an issue to the tracker, then responding by email to individuals from the mailing list who offered possible solutions. Some of the potentially useful information ended up in the tracker, but much of it got lost in emails that were more or less private. The record of what did and did not finally solve the problem is scattered about, not in a single place.

Moving to Github issues won't solve that - it would just move one of the places to a privately owned third party site over which we have no control.

We certainly would never want to try to move our primary communications to a tracker either - that would be horrific.
 
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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