From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Alexander Kirpa" <postgres(at)bilteks(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem |
Date: | 2006-10-04 15:13:27 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D2AE@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Alexander Kirpa [mailto:postgres(at)bilteks(dot)com]
> Sent: 04 October 2006 15:50
> To: pgadmin-support(at)postgresql(dot)org
> Subject: pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem
>
> 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
This has been fixed in beta 2.
> and
> a) not useful removing (lost) definition 'int2/4/8'
> from 'Data Types' in, for instance, 'New Column...'
pgAdmin now uses the spec compliant names for these types as PostgreSQL
does by default (integer, bigint etc).
> b) Query tool - not useful policy in case big size of 'Output pane'
> after 'Restore' of window size from Maximize(full) windows size
Sorry, I don't understand what you mean.
Regards Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2006-10-04 16:49:21 | Re: [SQL] How to overwrite a table [only data]? |
Previous Message | Aaron Bono | 2006-10-04 14:55:49 | Re: [SQL] How to overwrite a table [only data]? |