-->-----Mensagem original-----
-->De: pgadmin-support-owner@postgresql.org
-->[mailtogadmin-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.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match