[mapguide-users] feature class in mapguide studio
dorra2007
dorrdor at yahoo.fr
Wed Dec 5 09:55:11 EST 2007
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 <dorrdor at yahoo.fr> 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 <dorrdor at yahoo.fr> 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
>>>> >> mapguide-users at lists.osgeo.org
>>>> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>> >>
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > Zac Spitzer -
>>>> > http://zacster.blogspot.com (My Blog)
>>>> > +61 405 847 168
>>>> > _______________________________________________
>>>> > mapguide-users mailing list
>>>> > mapguide-users at lists.osgeo.org
>>>> > 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
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>
>>>
>>>
>>>
>>> --
>>> Zac Spitzer -
>>> http://zacster.blogspot.com (My Blog)
>>> +61 405 847 168
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> 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.
More information about the mapguide-users
mailing list