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.
>> 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.
In response to
pgadmin-hackers by date
|Next:||From: Guillaume Lelarge||Date: 2007-12-12 22:47:52|
|Subject: Re: 1.8.1 timetable|
|Previous:||From: svn||Date: 2007-12-12 21:12:28|
|Subject: SVN Commit by dpage: r6893 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/dlg|