From: | "Alexander Kirpa" <pgdoc81(at)bilteks(dot)com> |
---|---|
To: | Dave Page <dpage(at)postgresql(dot)org> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Grid editor crash during row insert |
Date: | 2007-10-18 14:12:10 |
Message-ID: | 471793EA.22665.704CC8B8@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On 18 Oct 2007, at 12:04, Dave Page wrote:
> Alexander Kirpa wrote:
> In addition some suggestion about 'Types', especially 'System type'.
> > Possible exist reason for 'System type' need have separate place in
> > tree. In my case more 100 'System type' etc. plus only approx. 10
> > real 'Types' that too hide within 'System Types'
>
> System types live under the Catalogs node. What you are probably
> seeing is types created by contrib modules in the public schema.
Please try on empty DB with 'Show System Objects in the treeview':
CREATE TABLE i2(i2 smallint NOT NULL,CONSTRAINT i2_pk PRIMARY KEY
(i2));
and see "system" type 'i2' in 'Types'
In case 100-200 tables DB with 5-10 "user" 'Types' - "system" 'Types'
only waste space and hide important "user" types plus hints for
"system" type wrong:
1. Impossible DROP and/or MODIFY 'System Types'
2. Impossible change owner of 'System Type' over 'Properties'
Possible solution:
a) Separate branch under 'Schemas'->(public)->'System Types'/'Table
Types' or
b) Separate branch under appropriate table 'Schemas'->(public)-
>'Tables'->(i2)->'Types'
Best regards,
Alexander Kirpa
>
> Regards, Dave.
>
>
Best regards,
Alexander Kirpa
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-10-18 14:36:16 | Re: Grid editor crash during row insert |
Previous Message | Guillaume Lelarge | 2007-10-18 11:29:37 | Re: Wish list and Doc Errors |