Re: [mapguide-users] feature class in mapguide studio
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 >> mapguide-users@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@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@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@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. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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 >>> >> mapguide-users@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@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@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@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#a14168482 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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 >> >> mapguide-users@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@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@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@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#a14168019 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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 > >> mapguide-users@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@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
yes, of course, all tables have geometry field JotaroKujo wrote: > > > dorra2007 wrote: >> >> 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.) >> > > I use the FDO Oracle Provider, and I see all the tables that have a > GEOMETRY field. > > All the 7 tables contain a geometric field? > > > > > -- View this message in context: http://www.nabble.com/feature-class-in-mapguide-studio-tf4935604s16610.html#a14153530 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
dorra2007 wrote: > > 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.) > I use the FDO Oracle Provider, and I see all the tables that have a GEOMETRY field. All the 7 tables contain a geometric field? -- View this message in context: http://www.nabble.com/feature-class-in-mapguide-studio-tf4935604s16610.html#a14151762 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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 >> mapguide-users@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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 > mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
I get this problem when using ODBC to SQL Server (2000/2005) My theory is that it is some bug or feature of FDO that is caching the database schema information. As a result, schema changes (eg. Add/Removed table. Add/Removed/Renamed columns in a table) are not reflected immediately. - Jackie 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#a14145738 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] feature class in mapguide studio
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#a14128060 Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users