Обсуждение: PostGIS/ PostGreSQL ODBC problem
Hi all, I am using the PostGIS to do research. Here I think that I found a bug with= PostGreSQL / PostGIS. PostgreSQL 7.1.3/ PostGIS 0.6.2 There is a function called "Astext" in PostGIS, defined as below. -- Function: astext(geometry) CREATE FUNCTION "astext"("geometry") RETURNS "text" AS 'astext_geometry= ' LANGUAGE 'C' WITH (ISSTRICT); When I used this function to return a geometry column, everything is OK if = the result was less than 8190. I used the ODBC to get the ADO RecordSet. The DefinedSize of the field "as= text" is 8190.=20=20 Does this the PostgreSQL's ODBC problem? If the ODBC can not get the field= 's size, would it give the size of 8190? Or this is the PostGIS's problem? Best regards, Tony --- Tony Jiang, MSc Research & Development Programmer/Analyst MRF Geosystems Corp (www.mrf.com) Suite 700, 665 8th Street SW,=20 Calgary, AB T2P 3K7 (403) 216-5515 ext:226
> "TONY J.Y." wrote: > > Hi all, > > I am using the PostGIS to do research. Here I think that I found a bug > with PostGreSQL / PostGIS. > PostgreSQL 7.1.3/ PostGIS 0.6.2 > > There is a function called "Astext" in PostGIS, defined as below. > -- Function: astext(geometry) > CREATE FUNCTION "astext"("geometry") RETURNS "text" AS > 'astext_geometry' LANGUAGE 'C' WITH (ISSTRICT); > When I used this function to return a geometry column, everything is > OK if the result was less than 8190. > I used the ODBC to get the ADO RecordSet. The DefinedSize of the > field "astext" is 8190. > > Does this the PostgreSQL's ODBC problem? If the ODBC can not get the > field's size, would it give the size of 8190? Are you using the psqlodbc driver whose version >= 7.01.0006 ? If so you could increase the size(8190) by setting MaxLongVarChar driver option using ODBC DataSource Administarator. You may be able to set the size to 0(unlimited?). regards, Hiroshi Inoue