PostGIS/ PostGreSQL ODBC problem - Mailing list pgsql-bugs

From TONY J.Y.
Subject PostGIS/ PostGreSQL ODBC problem
Date
Msg-id 004301c18743$c673c900$7a01a8c0@Aqua.MRF
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unable to compare _bpchar for similarity in WHERE-clause
Next
From: Hiroshi Inoue
Date:
Subject: Re: PostGIS/ PostGreSQL ODBC problem