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

Re: Foreign key dialog

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Foreign key dialog
Date: 2007-12-12 22:42:13
Message-ID: 476063C5.5050806@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> I was looking at a foreign key details. I wonder why the "FK index name"
>> is only available on the dialog. Or is it the same thing that the
>> "Covering index" on the details table ?
> 
> I believe so, yes. The naming difference could be fixed I guess.
> 

I'll check that and fix if necessary.

>> Last one (and this is why I'm looking at this right now), if I drop this
>> index and display the details of the foreign key with the foreign key
>> dialog, I see that a name is displayed despite the fact that there's no
>> such index. And the SQL tab says nothing has changed because the auto
>> index checkbox is not checked.
>>
>> All this seems a bit disturbing.
> 
> Not surprising - dropping the index doesn't cause the FK object to be
> refreshed. That would actually be quite difficult I imagine as there is
> no direct link between the two.
> 

OK.

>> ISTM that either the "Auto Index" checkbox should be checked or the "FK
>> index name" should be disabled till "Auto Index" checkbox is checked.
> 
> The checkbox tells pgAdmin to create an index with the specified name to
> cover the FK columns. When looking at the properties later, it will
> always be cleared - though I guess it might be better to set it if there
> is an index, and disable both it and the index name field.
> 
> Are you going to tweak that with the other stuff you were going to do?
> 

Which other stuff ? the stuff I told on my "1.8.1 timetable" answer ?

Anyways, I'll look at the fk stuff tomorrow morning. I'll take some time
to do it.



-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

In response to

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2007-12-12 22:47:52
Subject: Re: 1.8.1 timetable
Previous:From: svnDate: 2007-12-12 21:12:28
Subject: SVN Commit by dpage: r6893 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/dlg

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