Re: Grid editor crash during row insert

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

In response to

Responses

Browse pgadmin-support by date

  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