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?
Or this is the PostGIS's problem?
Tony Jiang, MSc
Research & Development Programmer/Analyst
MRF Geosystems Corp (www.mrf.com)
Suite 700, 665 8th Street SW,
Calgary, AB T2P 3K7
(403) 216-5515 ext:226
pgsql-bugs by date
|Next:||From: TONY J.Y.||Date: 2001-12-17 21:42:50|
|Subject: PostGIS/ PostGreSQL ODBC problem |
|Previous:||From: Vivek Khera||Date: 2001-12-17 20:43:36|
|Subject: missing instruction for "client-only" install|