Re: Hi, I'm looking the best way of doing edition of relationship figure metadata at database designer

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Luis Ochoa <ziul1979(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Hi, I'm looking the best way of doing edition of relationship figure metadata at database designer
Date: 2011-06-06 21:10:52
Message-ID: 1307394652.2063.13.camel@laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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.

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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Vinicius Santos 2011-06-07 00:51:44 Re: Update functions and trigger functions by clicking
Previous Message Luis Ochoa 2011-06-06 20:57:37 Hi, I'm looking the best way of doing edition of relationship figure metadata at database designer