pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem

Поиск
Список
Период
Сортировка
От Alexander Kirpa
Тема pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
Дата
Msg-id 4523F437.8850.3D76A48A@localhost
обсуждение исходный текст
Ответы Re: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
Список 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 по дате отправления:

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: [SQL] How to overwrite a table [only data]?
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem