Обсуждение: PG Admin III crash when inserting row in view window

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

-->-----Mensagem original-----
-->De: pgadmin-support-owner@postgresql.org
-->[mailto:pgadmin-support-owner@postgresql.org] Em nome de Dave Page
-->Enviada em: quinta-feira, 9 de novembro de 2006 06:14
-->Para: Alejandro Michelin Salomon ( Adinet )
-->Cc: Pgadmin-Support
-->Assunto: Re: [pgadmin-support] 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
-->
-->---------------------------(end of
-->broadcast)---------------------------
-->TIP 4: Have you searched our list archives?
-->
-->               http://archives.postgresql.org
-->

Dave :
I download and install the pgadmin 1.6 rc2, i use the upgrade.bat to
install.

The crahes still happening.

I configured my pgadmin with File -> Options -> Logging ( Error, Notices,
Sql ).

I attach to this mail amichelin1.log file with the crash log.

Alejandro.

Alejandro Michelin Salomon ( Adinet ) wrote:

> 
> Dave :
> I download and install the pgadmin 1.6 rc2, i use the upgrade.bat to
> install.
> 
> The crahes still happening.
> 
> I configured my pgadmin with File -> Options -> Logging ( Error, Notices,
> Sql ).
> 
> I attach to this mail amichelin1.log file with the crash log.

There doesn't seem to be any obvious problems in the logfile. Have you 
ever altered the table definition in any way? Can you try recreating the 
problem in a test database please?

Regards, Dave.