From 7e4c22248a4734dda15e34dd88822c6a927b9dda Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 6 Dec 2011 14:40:21 +0000 Subject: [PATCH] put some obsolete notes in existing management functions. Now that raster_columns is a view no longer need to use management functions to drop or add raster columns or tables. Will document the new addconstraints etc. taht replaces much of these soon. git-svn-id: http://svn.osgeo.org/postgis/trunk@8308 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_raster.xml | 24 +++++++++++++----------- 1 file changed, 13 insertions(+), 11 deletions(-) diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index 9b26a7a42..505e9b966 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -461,7 +461,7 @@ VALUES (1, AddRasterColumn - Adds a raster column to an existing table and generates column constraint on the new column to enforce srid. + deprecated: Adds a raster column to an existing table and generates column constraint on the new column to enforce srid. @@ -611,8 +611,8 @@ VALUES (1, raster2pgsql.py loader uses this function to register raster tables - Views and derivatively created spatial tables will need to be registered in raster_columns manually, - since AddRasterColumn also adds a raster column which is not needed when you already have a raster column. + This function is deprecated and will be removed in later versions. Instead just create a raster column + using CREATE TABLE .. or ALTER TABLE .. ADD COLUMN rast raster; and then use the AddRasterConstraints function. @@ -651,7 +651,7 @@ UPDATE raster_columns SET extent = (SELECT ST_Union(ST_Envelope(rast)) FROM myra DropRasterColumn - Removes a raster column from a table. + Obsolete: just use sql ALTER TABLE DROP COLUMN: Removes a raster column from a table. @@ -700,18 +700,20 @@ UPDATE raster_columns SET extent = (SELECT ST_Union(ST_Envelope(rast)) FROM myra Description - Removes a raster column from a table. Note that - schema_name will need to match the r_table_schema field of the table's - row in the raster_columns table. + Obsolete and will be removed in later versions. Instead just drop the column using standard SQL. Examples - SELECT DropRasterColumn ('my_schema','my_raster_table','rast'); - ----RESULT output --- - my_schema.my_raster_table.rast effectively removed. +-- NOTE this is obsolete +SELECT DropRasterColumn ('my_schema','my_raster_table','rast'); +----RESULT output --- +my_schema.my_raster_table.rast effectively removed. + + -- Instead do -- +ALTER TABLE my_schema.my_raster_table DROP COLUMN rast; See Also @@ -724,7 +726,7 @@ UPDATE raster_columns SET extent = (SELECT ST_Union(ST_Envelope(rast)) FROM myra DropRasterTable - Drops a table and all its references in + Obsolete: Instead use DROP TABLE mytable. Drops a table and all its references in raster_columns. -- 2.40.0