[postgis-tickets] r16600 - [doc] fix xml structure
Darafei
komzpa at gmail.com
Fri Jun 1 04:20:24 PDT 2018
Author: komzpa
Date: 2018-06-01 04:20:23 -0700 (Fri, 01 Jun 2018)
New Revision: 16600
Modified:
trunk/doc/using_postgis_dataman.xml
Log:
[doc] fix xml structure
Modified: trunk/doc/using_postgis_dataman.xml
===================================================================
--- trunk/doc/using_postgis_dataman.xml 2018-06-01 11:00:24 UTC (rev 16599)
+++ trunk/doc/using_postgis_dataman.xml 2018-06-01 11:20:23 UTC (rev 16600)
@@ -702,11 +702,11 @@
<para>Creating a table with spatial data, can be done in one step. As shown in the following example
which creates a roads table with a 2D linestring geometry column in WGS84 long lat</para>
- <programlisting>CREATE TABLE ROADS ( ID int4
- , ROAD_NAME varchar(25), geom geometry(LINESTRING,4326) );</programlisting>
+ <programlisting>CREATE TABLE ROADS (ID serial, ROAD_NAME text, geom geometry(LINESTRING,4326) );</programlisting>
<para>We can add additional columns using standard ALTER TABLE command as we do in this next example where we add a 3-D linestring.</para>
<programlisting>ALTER TABLE roads ADD COLUMN geom2 geometry(LINESTRINGZ,4326);</programlisting>
+ </sect2>
<sect2 id="Manual_Register_Spatial_Column">
<title>Manually Registering Geometry Columns in geometry_columns</title>
@@ -2202,7 +2202,6 @@
normal B-Tree indexes. Once you have run your query, you should
consider setting <varname>ENABLE_SEQSCAN</varname> back on, so that
other queries will utilize the planner as normal.</para>
- </note>
</listitem>
<listitem>
More information about the postgis-tickets
mailing list