I'm having the same problem, so any advice would be most welcomed. -Tom
On 11/10/05, Justin Deoliveira <[EMAIL PROTECTED]> wrote: > The problem I am seeing is that teh fidMapper is being used when a table > does not exist. This is the comment from the Jira Task you created: > > "The createSchema() function of the PostgisDataStore doesn't work. First > it checks to see if the table to be created is not already present, but > then it asks the FIDMapper for the table's PKs. > The org.geotools.data.jdbc.fidmapper.getPkColumnInfo() throws a > SchemaNotFoundException that cause the createSchema() to fail. > A solution would be to return a new ColumnInfo[0] instead, so that the > buildNoPKMapper() function would be called. > The problem is that FeatureType and AttributeType have no notion of PKs, > so how can the buildNoPKMapper() function knows which fields are Pks??? > I have a fixed version of PostgisDataStore (albeit it's not general > enough to be used as is). Where and how can I submit it???" > > Which is the exact problem I am having. Does your version of > PostgisDataStore solve this? > > Justin > > P.Rizzi Ag.Mobilità Ambiente wrote: > > > > The Primary Keys problem is still there, since there's > > no notion of them in GeoTools but, apart from that, > > the createSchema() should work. > > Anyway I always used my own modified version of the > > PostgisDataStore that has its own metadata support for PKs, > > so I'm not sure if the "normal" PostgisDataStore.createSchema() > > actually works. You can try it and see what it does. > > The case-sensitiveness bugs should have all been fixed. > > Anyway I recently started an implementation of createSchema() > > for the OracleDataStore with a different solution for the PKs > > problem, so I may be able to port it to the PostgisDataStore too. > > I have to find time to look into this better. I'll let the list > > know when I come up with a solution. > > > > Bye > > Paolo Rizzi > > > > > > -----Original Message----- > > From: Tom Howe > > To: [email protected] > > Sent: 09/11/2005 19.38 > > Subject: [Geotools-gt2-users] problem creating schema in postgis > > > > Hi, > > I saw a message on the list from january that said that createSchema() > > for the postgis data store doesn't work. Is this still the case? > > > > Thanks, > > Tom > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. > > Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Geotools-gt2-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users > > > > > > > > > > AVVERTENZE AI SENSI DEL D. LGS. 196/2003 > > Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i > > file/s allegato/i, sono da considerarsi strettamente riservate. Il loro > > utilizzo è consentito esclusivamente al destinatario del messaggio, per le > > finalità indicate nel messaggio stesso. Qualora riceveste questo messaggio > > senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia > > via e-mail e di procedere alla distruzione del messaggio stesso, > > cancellandolo dal Vostro sistema; costituisce comportamento contrario ai > > principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio stesso, > > divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od > > utilizzarlo per finalità diverse. > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Geotools-gt2-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users > > > > > -- > Justin Deoliveira > The Open Planning Project > http://topp.openplans.org > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
