Обсуждение: the menu "view/edit data / all rows" strange thing

Поиск

Список

Период

Сортировка

the menu "view/edit data / all rows" strange thing

От

Daniel Vos

Дата:

10 августа 2019 г., 11:59:02

Hi all,

I use pgadmin 4.11 on windows 10 ( firefox or opera -> same thing),
with all tables of more than 1000 rows,
if I use the contextual menu  "view / edit data / all rows", the grid
result show 1000 rows.
if I refresh de query all rows showed

daniel

Re: the menu "view/edit data / all rows" strange thing

От

Aditya Toshniwal

Дата:

12 августа 2019 г., 05:42:43

Hi Daniel,

This will be fixed in upcoming release.

On Sat, Aug 10, 2019 at 5:29 PM Daniel Vos <danielv8888@gmail.com> wrote:

Hi all,

I use pgadmin 4.11 on windows 10 ( firefox or opera -> same thing),
with all tables of more than 1000 rows,
if I use the contextual menu "view / edit data / all rows", the grid
result show 1000 rows.
if I refresh de query all rows showed

daniel

Thanks and Regards,

Aditya Toshniwal

Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"

Re: the menu "view/edit data / all rows" strange thing

От

Dave Page

Дата:

28 июля 2022 г., 16:13:08

On Thu, 28 Jul 2022 at 17:08, Roberto Tagliaferri - Tosnet srl <r.tagliaferri@tosnet.it> wrote:

I reopen this old post: i see 1000 rows everytime
If i select no limits i see at bottom of the window
Total rows: 1000 of 2065 Query complete 00:00:02.006

Yes, meaning the query returned 2065 rows, and pgAdmin has so far retrieved the first batch of 1000.

If you scroll to the end of the results, it'll automatically fetch the next 1000 and add them to the grid.

if i select 1000 rows of limit
Total rows: 1000 of 1000 Query complete 00:00:00.482

Makes sense - you've set the limit to the same as the size of the batches that are retrieved.

no limits is.. without limits :)

Il 12/08/19 07:42, Aditya Toshniwal ha scritto:
Hi Daniel,

This will be fixed in upcoming release.

On Sat, Aug 10, 2019 at 5:29 PM Daniel Vos <danielv8888@gmail.com> wrote:
Hi all,

I use pgadmin 4.11 on windows 10 ( firefox or opera -> same thing),
with all tables of more than 1000 rows,
if I use the contextual menu "view / edit data / all rows", the grid
result show 1000 rows.
if I refresh de query all rows showed

daniel

--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

--
Roberto Tagliaferri
Amministrazione di sistema | TosNet s.r.l. Internet Service Provider
Via F.lli Giachetti, 28/3
59100 Prato (PO)
www.tosnet.it
Office: +39 0574 875 100
Mobile: +39 329 591 3899
Skype: ilrobyt

Ai sensi del Reg. EU n. 679/16 (GDPR) si precisa che le informazioni contenute nella presente mail, nonché gli eventuali allegati, sono riservate e ad uso esclusivo dei destinatari.
Stai ricevendo la presente mail in quanto sei cliente di TosNet S.r.l., utilizzi uno o più dei nostri servizi o semplicemente perchè stiamo dando ad una tua richiesta che ci è pervenuta per iscritto, tramite una procedura, di persona o telefonicamente.
Qualora la presente mail ti fosse pervenuta per errore, ti preghiamo di eliminarla (senza diffusione a terzi o copiatura delle informazioni/documenti trasmessi, anche solo parziale), dandocene gentilmente comunicazione immediata.