pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem - Mailing list pgadmin-support

From Alexander Kirpa
Subject pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
Date
Msg-id 4523F437.8850.3D76A48A@localhost
Whole thread Raw
Responses Re: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
List pgadmin-support
During editing table within grid editor
receive next error:
2006-10-04 16:57:27 9261 ERROR:  type "pg_catalog.smallint" does not 
exist at character 103
2006-10-04 16:57:27 9261 STATEMENT:  UPDATE axxxxxxxxxxxx SET 
titlexxxxxxxxxxxx='Qxxxxxxxxxxxxxxxxx'::pg_catalog.text
WHERE axxx = '1047'::pg_catalog."smallint"
(axxx - int2) - similar problem should exist for integer and bigint, 
because in pg_catalog.pg_type exist only int2/4/8,
but psql in \d+ use smallint etc.
After replace smalint on int2 in 'Query tool' - no error

and
a) not useful removing (lost) definition 'int2/4/8'
from 'Data Types' in, for instance, 'New Column...'
b) Query tool - not useful policy in case big size of 'Output pane' 
after 'Restore' of window size from Maximize(full) windows size

Best regards,Alexander Kirpa



pgadmin-support by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: [SQL] How to overwrite a table [only data]?
Next
From: "Dave Page"
Date:
Subject: Re: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem