Re: PG Admin III crash when inserting row in view

Alejandro Michelin Salomon ( Adinet ) wrote:
> Hi :
>  
> Plataform : windows XP SP2.
> Language  : Englihs
> Installation Binary, from windows installer ( Downloaded file 
> pgadmin3-1.6.0-beta3.zip )
>  
> Vercion : 1.6 Beta 3 ( Oct 12 2006, rev: 5475 )
>  
>  
> Problem :
>  
> I has a table width 5 fields.
>  
> -- hd_tecnicos
> CREATE SEQUENCE hd_tecnicos_idtecnico_seq;
> CREATE TABLE hd_tecnicos
> (
>   idtecnico int4 NOT NULL DEFAULT 
> nextval('hd_tecnicos_idtecnico_seq'::text),
>   idempresa int4 NOT NULL DEFAULT 0,
>   ativo int2 NOT NULL DEFAULT 0,
>   idusuario int4 NOT NULL DEFAULT 0, -- Usuário do sistema.
>   idpessoa int4 NOT NULL DEFAULT 0, -- Número pessoa para poder criar as 
> contas a pagar.
>   CONSTRAINT hd_tecnicos_PK PRIMARY KEY (idempresa, idusuario)
> )
> WITHOUT OIDS;
>  
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 1);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 2);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 3);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 4);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 5);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 6);
> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario ) VALUES ( 1, 1, 9);
> This table has 7 records.
>  
> I open the view window. To see the rows from hd_tecnicos.
>  
> I the row mark as '*' i type :
>  
> Value 1 for idempresa, value 1 for ativo, value 13 for idusuario.
>  
> Note :
> For the colummn idtecnico i dont fill width data becouse the 
> nextval('hd_tecnicos_idtecnico_seq'::text) has to get the
> next valueand fill them.
> When i am in the column idusuario and press enter pgadmin crashes.
>  
> I dont have a error reporting becouse is a binary installation.

This works perfectly for me in RC2, which does include a bug fix related 
to primary keys that aren't in the first columns. Can you try that 
version please: http://www.pgadmin.org/download/windows.php

If that crashes for you as well, can you switch on logging to "Errors, 
Notices, SQL" under File -> Options -> Logging, recreate the crash, and 
then send the logfile please?

Regards, Dave