Remark: What I have noticed that the spatial tables that are reflected in mapguide studio are stored (their names, the name of the geometry column, the geometry type,...etc) in a specific table called geometry_columns. And when I create new spatial tables, not all the new created tables are stored in the gemetry_columns table: this is the origin of the problem. So, I deduce that the bug comes from postgis.
dorra2007 wrote: > > 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#a14172997 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
