[postgis-users] bug in create_undef.sql

klaus Förster klaus.foerster at uibk.ac.at
Thu Jul 7 06:19:42 PDT 2005


there's a bug in create_undef.pl for postgis version 1.0.2
if you run it with the appropriate lwpostgis.sql and version 80,
the resulting sql-code is invalid in the following line:

DROP TYPE geometry_dump AS  CASCADE;

this is the result of a false regexp in create_undef.pl.
using \w+ instead of [^(]+ should solve the problem

klaus

--- create_undef.pl  2005-07-07 14:49:02.000000000 +0200
+++ fixed.pl   2005-07-07 14:48:55.000000000 +0200
@@ -140,7 +140,7 @@

  foreach my $type (@types)
  {
-  if ($type =~ /create type ([^(]+)/i )
+  if ($type =~ /create type (\w+)/i )
    {
       if ( $version ge "73" )
       {

-- 
          O-.
          /_ )
           | (U
klaus*   /|
         / /
         ~ ~



More information about the postgis-users mailing list