Just one more question, if you don't mind. Which type of index is the most appropriate in this case: B-tree, Hash, GiST or GIN. And the column which may be indexed is the geometry column, isn't it?
dorra2007 wrote: > > Great, I create indexes on the geometry column and that resolves partially > my problem. In fact, I have to create a new feature source using the same > database to make updates effective. > > Thank vey much you anyway. > > > zspitzer wrote: >> >> no they look fine, it was just a wild card....... >> >> do they all have spatial indexes defined? >> >> z >> >> On Dec 5, 2007 1:29 AM, dorra2007 <[EMAIL PROTECTED]> wrote: >>> >>> The tables names: repere, historique, kangoo, test, interet, sol, >>> route... >>> >>> I can get in maguide studio only: sol and route.. >>> >>> Do you think that the other names are too long? >>> >>> >>> >>> zspitzer wrote: >>> > >>> > in the old mapguide, if you had very long table names, the ide >>> > (mapguide author?) would have >>> > problems unless you made them shorter.... can you show us a list of >>> > the table names? >>> > >>> > On Dec 4, 2007 8:13 PM, dorra2007 <[EMAIL PROTECTED]> wrote: >>> >> >>> >> I have deleted and recreated the connection, sometimes have one new >>> >> table >>> >> reflected in mapguide studio, sometimes not. >>> >> The most blocking thing is that in any case, the number of tables >>> >> reflected >>> >> doesn't exceed four. I mean, when I have more than four tables (7 for >>> >> example), I have, as maximum, only four tables reflected in mapguide >>> >> studio >>> >> (if, of course, I succeed to get them in mapguide studio.) >>> >> >>> >> Have you encountered such problem (a max number of tables that can be >>> >> displayed.) >>> >> >>> >> >>> >> >>> >> JotaroKujo wrote: >>> >> > >>> >> > >>> >> > dorra2007 wrote: >>> >> >> >>> >> >> but when I want to update my database (I added new spatial table >>> to >>> >> the >>> >> >> postgis database), the featureSource is not updated, and I can't >>> >> create a >>> >> >> new layer using the new table (because it's not displayed in the >>> >> feature >>> >> >> class list.) >>> >> >> >>> >> > >>> >> > I have found the same problem with Oracle 10g (I use the Autodesk >>> >> > commercial FDO). >>> >> > If you delete the connection, and recreate it...you will find the >>> new >>> >> > tables in the list. >>> >> > >>> >> > May be when a connection is created, the server creates a file >>> >> containing >>> >> > the database catalogue structure. >>> >> > >>> >> >>> >> -- >>> >> View this message in context: >>> >> >>> http://www.nabble.com/feature-class-in-mapguide-studio-tf4935604s16610.html#a14147147 >>> >> >>> >> Sent from the MapGuide Users mailing list archive at Nabble.com. >>> >> >>> >> _______________________________________________ >>> >> mapguide-users mailing list >>> >> [email protected] >>> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >>> > >>> > >>> > >>> > -- >>> > Zac Spitzer - >>> > http://zacster.blogspot.com (My Blog) >>> > +61 405 847 168 >>> > _______________________________________________ >>> > mapguide-users mailing list >>> > [email protected] >>> > http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> > >>> > >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/feature-class-in-mapguide-studio-tf4935604s16610.html#a14151701 >>> >>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> mapguide-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- View this message in context: http://www.nabble.com/feature-class-in-mapguide-studio-tf4935604s16610.html#a14168482 Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
