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

From: "Alexander Kirpa" <postgres(at)bilteks(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
Date: 2006-10-04 14:49:43
Message-ID: 4523F437.8850.3D76A48A@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aaron Bono 2006-10-04 14:55:49 Re: [SQL] How to overwrite a table [only data]?
Previous Message Harald Armin Massa 2006-10-04 11:50:36 Re: How to overwrite a table [only data]?