Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group