PostGIS/ PostGreSQL ODBC problem

From: "TONY J(dot)Y(dot)" <tjiang(at)mrf(dot)com>
To: "postgis members" <postgis(at)yahoogroups(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: PostGIS/ PostGreSQL ODBC problem
Date: 2001-12-17 21:42:50
Message-ID: 004301c18743$c673c900$7a01a8c0@Aqua.MRF
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 "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?

Best regards,
Tony

---
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Inoue 2001-12-17 23:54:15 Re: PostGIS/ PostGreSQL ODBC problem
Previous Message Yuan Jiang (tony) 2001-12-17 20:49:44 PostGIS/ PostGreSQL ODBC problem