On 7 March 2011 10:18, Dave Page <dpage@pgadmin.org> wrote:
> On Sun, Mar 6, 2011 at 10:28 PM, Guillaume Lelarge
> <guillaume@lelarge.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?
Yes, I believe the purpose is to allow the creation of a foreign key
with far less disruptive locking meaning foreign keys can be created
in parallel.
Guillaume, you appear to have commented out an if container, while
also adding a condition to it. Is this supposed to be commented out
at all?..
+ //if (sql.IsNull() || forceRefresh)
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935