[postgis-users] About Invalid OGC WKT Error

[Koji Yano]

strk at refractions.net wrote:
> Is the lwpostgis.sql you loaded the one which came from
> RC1 or RC2 ?
> 

Sorry to be late to reply.
Your addices are just what I needed.
I created new database ,loaded lwpostgis.sql from RC2 and tested that.
Then I can insert data by the same SQL successfully.

Now I have a feeling that I made a mistake during upgrading.
Maybe in uploading dumpfiles when I upgraded PostgreSQL 8.0.0 to 8.0.1.
Thank you for your help.


> Can you post the output of this queries ?
>
> # SELECT proname, proargtypes from pg_proc where proname like
> '%fromtext' or proname like '%fromwkb';
> # SELECT oid, typname from pg_type where typname = 'geometry'
>  or typname = 'bytea' or typname = 'text';
>
> --strk;

Here is what I get.

# SELECT proname, proargtypes FROM pg_proc WHERE proname like
'%fromtext' or proname like '%fromwkb';
         proname         | proargtypes
-------------------------+-------------
 geomcollfromtext        |    38597 23
 geomcollfromtext        |       38597
 geomcollfromwkb         |    38597 23
 geomcollfromwkb         |       38597
 geometryfromtext        |       38597
 geometryfromtext        |    38597 23
 geomfromtext            |       38597
 geomfromtext            |    38597 23
 geomfromwkb             |          17
 geomfromwkb             |       17 23
 linefromtext            |       38597
 linefromtext            |    38597 23
 linefromwkb             |    38597 23
 linefromwkb             |       38597
 linestringfromtext      |       38597
 linestringfromtext      |    38597 23
 linestringfromwkb       |    38597 23
 linestringfromwkb       |       38597
 mlinefromtext           |    38597 23
 mlinefromtext           |       38597
 mlinefromwkb            |    38597 23
 mlinefromwkb            |       38597
 mpointfromtext          |    38597 23
 mpointfromtext          |       38597
 mpointfromwkb           |    38597 23
 mpointfromwkb           |       38597
 mpolyfromtext           |    38597 23
 mpolyfromtext           |       38597
 mpolyfromwkb            |    38597 23
 mpolyfromwkb            |       38597
 multilinefromwkb        |    38597 23
 multilinefromwkb        |       38597
 multilinestringfromtext |       38597
 multilinestringfromtext |    38597 23
 multipointfromtext      |    38597 23
 multipointfromtext      |       38597
 multipointfromwkb       |    38597 23
 multipointfromwkb       |       38597
 multipolyfromwkb        |    38597 23
 multipolyfromwkb        |       38597
 multipolygonfromtext    |    38597 23
 multipolygonfromtext    |       38597
 pointfromtext           |       38597
 pointfromtext           |    38597 23
 pointfromwkb            |    38597 23
 pointfromwkb            |       38597
 polyfromtext            |       38597
 polyfromtext            |    38597 23
 polyfromwkb             |    38597 23
 polyfromwkb             |       38597
 polygonfromtext         |    38597 23
 polygonfromtext         |       38597
 polygonfromwkb          |    38597 23
 polygonfromwkb          |       38597
(54 rows)

# SELECT oid, typname FROM pg_type WHERE typname = 'geometry' or
typname='bytea' or typname='text';
  oid  | typname
-------+----------
    17 | bytea
    25 | text
 38597 | geometry
(3 rows)

And here is the output of same queries from new created database.
I think this is the proper result.

gistest2=# SELECT proname, proargtypes FROM pg_proc WHERE proname like
'%fromtext' or proname like '%fromwkb';
         proname         | proargtypes
-------------------------+-------------
 geometryfromtext        |          25
 geometryfromtext        |       25 23
 geomfromtext            |          25
 geomfromtext            |       25 23
 pointfromtext           |          25
 pointfromtext           |       25 23
 linefromtext            |          25
 linefromtext            |       25 23
 linestringfromtext      |          25
 linestringfromtext      |       25 23
 polyfromtext            |          25
 polyfromtext            |       25 23
 polygonfromtext         |       25 23
 polygonfromtext         |          25
 mlinefromtext           |       25 23
 mlinefromtext           |          25
 multilinestringfromtext |          25
 multilinestringfromtext |       25 23
 mpointfromtext          |       25 23
 mpointfromtext          |          25
 multipointfromtext      |       25 23
 multipointfromtext      |          25
 mpolyfromtext           |       25 23
 mpolyfromtext           |          25
 multipolygonfromtext    |       25 23
 multipolygonfromtext    |          25
 geomcollfromtext        |       25 23
 geomcollfromtext        |          25
 geomfromwkb             |          17
 geomfromwkb             |       17 23
 pointfromwkb            |       17 23
 pointfromwkb            |          17
 linefromwkb             |       17 23
 linefromwkb             |          17
 linestringfromwkb       |       17 23
 linestringfromwkb       |          17
 polyfromwkb             |       17 23
 polyfromwkb             |          17
 polygonfromwkb          |       17 23
 polygonfromwkb          |          17
 mpointfromwkb           |       17 23
 mpointfromwkb           |          17
 multipointfromwkb       |       17 23
 multipointfromwkb       |          17
 multilinefromwkb        |       17 23
 multilinefromwkb        |          17
 mlinefromwkb            |       17 23
 mlinefromwkb            |          17
 mpolyfromwkb            |       17 23
 mpolyfromwkb            |          17
 multipolyfromwkb        |       17 23
 multipolyfromwkb        |          17
 geomcollfromwkb         |       17 23
 geomcollfromwkb         |          17
(54 rows)

gistest2=# SELECT oid, typname FROM pg_type WHERE typname = 'geometry'
or typname='bytea' or typname='text';
  oid  | typname
-------+----------
    17 | bytea
    25 | text
 59166 | geometry
(3 rows)

Thank you for your nice advice!

Koji Yano
http://www.officeyano.net