[postgis-users] About Invalid OGC WKT Error

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Markus Schaber
> Sent: Thursday, 03 February, 2005 10:36
> To: PostGIS Users Discussion
> Cc: Kralidis,Tom [Burlington]
> Subject: Re: [postgis-users] About Invalid OGC WKT Error
> 
> 
> Hi, Tom,
> 
> Kralidis,Tom [Burlington] schrieb:
> >>It looks like the PostGIS side is working correctly... Are
> >>you connecting to your database using the same username as 
> >>password as in your Mapserver connection string?
> > 
> > Yup.  I'm using MapServer as a WMS/WFS.  MapServer is partly 
> > connecting using the DescribeFeatureType request, which 
> basically is 
> > the same as a \d <tablename> in psql.  So if this was 
> failing too, I'd 
> > be looking deeper into connection issues.
> 
> Can you turn logging on in your PostgreSQL server (especially 
> statement logging and warnings and such), and send us the 
> output produced during your connection attempts?
> 

LOG:  connection received: host=[local] port=
LOG:  connection authorized: user=postgres database=devgeodb
LOG:  statement: BEGIN
LOG:  statement: DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from service_endpoints WHERE the_g
eom && setSRID('BOX3D(-141.089 36.392987,-52.089 89.784987)'::BOX3D, find_srid('','service_endpoints','the_geom') )
LOG:  statement: FETCH ALL in mycursor
LOG:  statement: SELECT   $1  IS NULL
CONTEXT:  PL/pgSQL function "find_srid" line 6 at if
LOG:  statement: SELECT   $1  IS NULL
CONTEXT:  PL/pgSQL function "find_srid" line 9 at if
LOG:  statement: SELECT   $1  IS NULL
CONTEXT:  PL/pgSQL function "find_srid" line 12 at if
LOG:  statement: SELECT   $1
CONTEXT:  PL/pgSQL function "find_srid" line 15 at assignment
LOG:  statement: SELECT   $1
CONTEXT:  PL/pgSQL function "find_srid" line 16 at assignment
LOG:  statement: SELECT  (  $1  = '' and  $2  LIKE '%.%' )
CONTEXT:  PL/pgSQL function "find_srid" line 20 at if
LOG:  statement: SELECT   $1  || '%'
CONTEXT:  PL/pgSQL function "find_srid" line 24 at assignment
LOG:  statement: SELECT  SRID from geometry_columns where f_table_schema like  $1  and f_table_name =  $2  and f_geometry_column =  $3
CONTEXT:  PL/pgSQL function "find_srid" line 27 at select into variables
LOG:  statement: SELECT  NOT  $1
CONTEXT:  PL/pgSQL function "find_srid" line 28 at if
LOG:  statement: SELECT   $1
CONTEXT:  PL/pgSQL function "find_srid" line 31 at return
LOG:  statement: COMMIT


> Markus
> 
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53 
> mailto:schabios at logi-track.com | www.logi-track.com 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>