From: | CHERAT Francis <francis(dot)cherat(at)ratp(dot)fr> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | pgadmin4 crash on windows 7 |
Date: | 2017-04-18 14:26:53 |
Message-ID: | FF0CFBD667F47A419BEBDEE6240665D1109C0DB4@SV003318.info.ratp |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lazaro Garcia | 2017-04-18 15:06:15 | Re: Bug: Error generating backup |
Previous Message | Lazaro Garcia | 2017-04-18 13:57:08 | About pgadmin4 installation requirements. |