[postgis-users] documentation in svn

Stephen V. Mather svm at clevelandmetroparks.com
Tue Nov 1 12:27:58 PDT 2011


Hi All,

                Hope this is the right place to post this.  Just found a
minor typo in the following page:

 

http://www.postgis.org/documentation/manual-svn/using_postgis_dbmanagement.h
tml#geometry_columns

 

Also a problem here:

http://www.postgis.org/documentation/manual-1.5/ch04.html#geometry_columns

http://www.postgis.org/documentation/manual-1.4/ch04.html#id2759271

http://www.postgis.org/documentation/manual-1.3/ch04.html#id2571510

 

 

CREATE TABLE geometry_columns (

  f_table_catalog    VARRCHAR(256) NOT NULL,

  f_table_schema     VARCHAR(256) NOT NULL,

  f_table_name        VARCHAR(256) NOT NULL,

  f_geometry_column  VARCHAR(256) NOT NULL,

  coord_dimension    INTEGER NOT NULL,

  srid               INTEGER NOT NULL,

  type               VARCHAR(30) NOT NULL

)

 

The non-pirate version should be:

 

CREATE TABLE geometry_columns (
  f_table_catalog    VARCHAR(256) NOT NULL,
  f_table_schema     VARCHAR(256) NOT NULL,
  f_table_name        VARCHAR(256) NOT NULL,
  f_geometry_column  VARCHAR(256) NOT NULL,
  coord_dimension    INTEGER NOT NULL,
  srid               INTEGER NOT NULL,
  type               VARCHAR(30) NOT NULL
)

 

Now, who can guess which admin accidentally deleted his geometry_columns
table in order to discover this.  Maddening to fix in 1.3 too. .

 

Best,

Steve

 

 

http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather
Geographic Information Systems (GIS) Manager
(216) 635-3243

svm at clevelandmetroparks.com
 <http://www.clemetparks.com/> clevelandmetroparks.com

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111101/69019546/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3772 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111101/69019546/attachment.png>


More information about the postgis-users mailing list