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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
