Thread: Dev 1.15 Database Designer

Dev 1.15 Database Designer

From
Colin Beckingham
Date:
Thankyou for the recent changes, it looks a lot better regarding import 
of tables.

One remaining issue is that if the user selects a database which 
contains a schema but the schema contains no tables, the DD Import 
Tables dialog still proceeds even though there are no tables to import.

In the database design creation of new tables, there are some issues 
with deleting of tables in the design.

1. After delete of table in designer window, window does not refresh.
Example:
- import new table
- request delete of table
- dialog appears requesting info on delete from design or model
- select design only
- dialog disappears, but the table box does not
- click on the table in design window and table disappears
- is it possible to have the last step complete automatically?

2. Confusing delete of table object after delete from designer only
Example:
- import new table
- request delete
- dialog appears, user selects design window only
- user clicks on the table box in designer window and box disappears, 
but stays in browser - this is correct
- user realizes he pressed the wrong button,
looks for a way to delete the table from the model
- table delete icon is still active but does not operate on the browser 
window items
- right click on table name in browser panel produces no context 
sensitive floating menu
- one way to work around is to drag the table back into the designer and 
repeat the delete process, this time select option 'delete from model'
- suggestion 1: create right click context menu with delete table from 
browser which deletes the table from both browser and design (if 
necessary) windows together with any relationships, (possibly with 
warning dialog if relationships exist)
- suggestion 2: allow keyboard input 'delete' key to delete active table 
in browser

-- 
---
Colin Beckingham
613-454-5369
http://www.it4gh.com


Re: Dev 1.15 Database Designer

From
Guillaume Lelarge
Date:
On Fri, 2012-02-10 at 06:05 -0500, Colin Beckingham wrote:
> Thankyou for the recent changes, it looks a lot better regarding import 
> of tables.
> 
> One remaining issue is that if the user selects a database which 
> contains a schema but the schema contains no tables, the DD Import 
> Tables dialog still proceeds even though there are no tables to import.
> 

Oops, that should get fixed.

> In the database design creation of new tables, there are some issues 
> with deleting of tables in the design.
> 
> 1. After delete of table in designer window, window does not refresh.
> Example:
> - import new table
> - request delete of table
> - dialog appears requesting info on delete from design or model
> - select design only
> - dialog disappears, but the table box does not
> - click on the table in design window and table disappears
> - is it possible to have the last step complete automatically?
> 
> 2. Confusing delete of table object after delete from designer only
> Example:
> - import new table
> - request delete
> - dialog appears, user selects design window only
> - user clicks on the table box in designer window and box disappears, 
> but stays in browser - this is correct
> - user realizes he pressed the wrong button,
> looks for a way to delete the table from the model
> - table delete icon is still active but does not operate on the browser 
> window items
> - right click on table name in browser panel produces no context 
> sensitive floating menu
> - one way to work around is to drag the table back into the designer and 
> repeat the delete process, this time select option 'delete from model'
> - suggestion 1: create right click context menu with delete table from 
> browser which deletes the table from both browser and design (if 
> necessary) windows together with any relationships, (possibly with 
> warning dialog if relationships exist)
> - suggestion 2: allow keyboard input 'delete' key to delete active table 
> in browser
> 

OK, two more items to look at.

Thank you.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



Re: Dev 1.15 Database Designer

From
Guillaume Lelarge
Date:
On Fri, 2012-02-17 at 22:23 +0100, Guillaume Lelarge wrote:
> On Fri, 2012-02-10 at 06:05 -0500, Colin Beckingham wrote:
> > Thankyou for the recent changes, it looks a lot better regarding import 
> > of tables.
> > 
> > One remaining issue is that if the user selects a database which 
> > contains a schema but the schema contains no tables, the DD Import 
> > Tables dialog still proceeds even though there are no tables to import.
> > 
> 
> Oops, that should get fixed.
> 
> > In the database design creation of new tables, there are some issues 
> > with deleting of tables in the design.
> > 
> > 1. After delete of table in designer window, window does not refresh.
> > Example:
> > - import new table
> > - request delete of table
> > - dialog appears requesting info on delete from design or model
> > - select design only
> > - dialog disappears, but the table box does not
> > - click on the table in design window and table disappears
> > - is it possible to have the last step complete automatically?
> > 
> > 2. Confusing delete of table object after delete from designer only
> > Example:
> > - import new table
> > - request delete
> > - dialog appears, user selects design window only
> > - user clicks on the table box in designer window and box disappears, 
> > but stays in browser - this is correct
> > - user realizes he pressed the wrong button,
> > looks for a way to delete the table from the model
> > - table delete icon is still active but does not operate on the browser 
> > window items
> > - right click on table name in browser panel produces no context 
> > sensitive floating menu
> > - one way to work around is to drag the table back into the designer and 
> > repeat the delete process, this time select option 'delete from model'
> > - suggestion 1: create right click context menu with delete table from 
> > browser which deletes the table from both browser and design (if 
> > necessary) windows together with any relationships, (possibly with 
> > warning dialog if relationships exist)
> > - suggestion 2: allow keyboard input 'delete' key to delete active table 
> > in browser
> > 
> 
> OK, two more items to look at.
> 
> Thank you.
> 

BTW, I put all your requests on
http://code.pgadmin.org/trac/wiki/database-designer because I can't
really create tickets for them, and I need to remember them.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com