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

Re: Support for invalid foreign keys

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Support for invalid foreign keys
Date: 2011-03-07 04:48:00
Message-ID: AANLkTi=1RNPyTqg_NfczM2Y0DNs8bAbcFVG832euts5r@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Sun, Mar 6, 2011 at 10:28 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> Hi,
>
> This is a new (as in 9.1) feature we have to support in pgAdmin.
>
> From the git log on https://github.com/gleu/pgadmin3/tree/ticket304:
>
>  Add support for invalid foreign key constraints
>
>  This patch adds a checkbox in the dlgForeignKey dialog, so that the
>  user can create an "not validated" foreign key. Each foreign key of
>  this kind is displayed with the usual icon with a red cross on it. A
>  contextual menu allows the user to force the validation of the
>  constraint. The user can also do this via the dlgForeignKey dialog.

So it basically disables the constraint, leaving it as a sort of
documentation of intent?


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2011-03-07 04:50:27
Subject: Re: Feature: visual feedback of disabled triggers
Previous:From: Guillaume LelargeDate: 2011-03-06 22:44:20
Subject: Re: Feature: visual feedback of disabled triggers

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