Обсуждение: [pgadmin-support] pgadmin4 crash on windows 7

Поиск
Список
Период
Сортировка

[pgadmin-support] pgadmin4 crash on windows 7

От
CHERAT Francis
Дата:
 
Hello,
 
I want to see all rows of my table with this sql query on pgadmin4 v1.4 on my PC with windows 7.
 
Select * from  public.fil
 
this table as 930000 rows, the table size is 79Mo
 
the ddl is
CREATE TABLE public.fil
(
    identifiant integer NOT NULL,
    numero integer NOT NULL,
    numeroregroupement integer,
    id_tube integer,
    statut character(3) COLLATE pg_catalog."default",
    numero_tete_cable smallint,
    attribute1 character varying(25) COLLATE pg_catalog."default",
    attribute2 character varying(25) COLLATE pg_catalog."default",
    attribute3 character varying(25) COLLATE pg_catalog."default",
    connexion_origine character varying(5) COLLATE pg_catalog."default",
    connexion_extremite character varying(5) COLLATE pg_catalog."default",
    CONSTRAINT id_fil PRIMARY KEY (identifiant)
        USING INDEX TABLESPACE idx_1,
    CONSTRAINT fk_id_tube FOREIGN KEY (id_tube)
        REFERENCES public.tube (identifiant) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
)
 
After a long time pgadmin4 crash without message or log
 
This sql query work fine with pgadmin3 1.22.1 on the same PC but this is very slow 52s
 
 
Regards
Francis