Limit is before filter

From: Jonathan Knight <j(dot)knight(at)keele(dot)ac(dot)uk>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Limit is before filter
Date: 2023-07-26 09:02:16
Message-ID: CWLP265MB37777EE954E0FE766698ABC6D700A@CWLP265MB3777.GBRP265.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

I'm having some trouble with pgadmin 7.4.

The sequence is:

Use View/Edit Data -> First 100 rows

Then I apply a filter and I get no results, but if I take off the limit then I can see the correct results set. This wasn't a problem back at 7.0 and I'm a bit puzzled as to what could be the underlying problem which is making it a bit difficult to search the current issues to see if it's already been spotted.

Cheers

Jon

[https://lh3.googleusercontent.com/ZSHAsZIovAfYooPPH0QskmbCLDnp2iUQvlNpbwuiu7hphyj8Fs0Y4GrCKsm4tUdO9r9j77nxmMSGvzlKN9TvWrkGCgO7Aagj-ojSMXWIZoVQw6yAI6JDSbygoAm5l8L8drZEkJt_]

Dr Jonathan Knight

Enterprise Solutions Architect

Information and Digital Services

01782 733478

Innovation Centre 2 | Keele University | ST5 5NH

----------
Please consider the environment before printing this email.This email and its contents may be legally privileged and /or confidential.If it has come to you in error you should not copy or show it to anyone; nor should you take any action based on it, other than to reply to the sender to notify them of the error immediately and to then delete the email from your inbox and deleted items. Keele University staff and students are required to abide by the University's IT Policies when sending and receiving email. Keele University email is hosted by a cloud provider and may be stored outside of the UK.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Akshay Joshi 2023-07-27 06:51:44 pgAdmin 4 v7.5 Released
Previous Message Nuel Godfrey 2023-07-25 19:08:24 Re: Failed Pgadmin load