On Mon, 2011-06-06 at 16:27 -0430, Luis Ochoa wrote:
> I'm finishing the first goal of my database designer improvement
> project http://goo.gl/21rXu and now I'm adding a new metadata
> information to relationship objects, with info about: match, on
> delete, on update and table constraint name (for fk) as shown below:
> REFERENCES reftable...column constraint....FOREIGN KEY ( column [, ...
> ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ] [ MATCH matchtype ]
> [ ON DELETE action ] [ ON UPDATE action ] (table constraint)
> There are plenty ways of doing this but I have thought about two:
> 1. Allow user with a right click menu over relationship object to
> select in 4 different options that allow modification of all this
> information, user click at one item and then get a dialog or something
> like that to modify what he wants.
> 2. Create a dialog that contains all this info in a single point, and
> then allow user to invoke this with double click in relationship or
> just selecting one option of right click menu for this purpose.
> Any new ideas about how to do this?
> I just want some feedback from community to select the best way of
> doing this.
I prefer solution 1. Seems quicker and more intuitive.
In response to
pgadmin-hackers by date
|Next:||From: Vinicius Santos||Date: 2011-06-07 00:51:44|
|Subject: Re: Update functions and trigger functions by clicking|
|Previous:||From: Luis Ochoa||Date: 2011-06-06 20:57:37|
|Subject: Hi, I'm looking the best way of doing edition of relationship figure
metadata at database designer|