Skip site navigation (1) Skip section navigation (2)

PostGIS/ PostGreSQL ODBC problem

From: "Yuan Jiang \(tony\)" <tony_jy(at)hotmail(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 20:49:44
Message-ID: (view raw, whole thread or download thread mbox)
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 Jiang, MSc
Research & Development Programmer/Analyst
MRF Geosystems Corp (
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 KheraDate: 2001-12-17 20:43:36
Subject: missing instruction for "client-only" install

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group