Hi Michael, thank you very much for pointing this out!!! I never tested it with an unsized VARCHAR, always used some VARCHAR(XXX)... I'll fix it as soon as possible!!!
Bye Paolo Rizzi > -----Messaggio originale----- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] conto di > Michaël Michaud > Inviato: lunedì 14 maggio 2007 7.47 > A: List for discussion of JPP development and use. > Oggetto: Re: [JPP-Devel] R: R: OpenJUMP and postgreSQL/PostGIS > > > Hi Paolo > > >>Last question : I cannot get varchar fields in OpenJUMP with > >>SIS plugin, do you have an idea where it can come from ? > >> > >> > >I don't know, I never had problem with varchars... > >If you send me same non-working sample data (in the form of a > >CREATE TABLE+INSERT INTO text file), I'll test them!!! > > > > > Here is an example of field which is not correctly loaded by sisdb : > > CREATE TABLE test ( id INTEGER PRIMARY KEY, name VARCHAR NOT NULL ); > SELECT AddGeometryColumn ( 'postgis', 'test', 'geom', -1, > 'GEOMETRY', 2 ); > INSERT INTO test ( id, name, geom ) VALUES ( 1, 'geom 1', > GeometryFromText( 'POINT(1 1)', -1 ) ); > > Note that if you replace VARCHAR by VARCHAR(20), it works fine > > Cheers, > > Michael > > > > -------------------------------------------------------------- > ----------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
