From 225ecaeeb6f31c099522b5fc1a0e447506a3786a Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Tue, 20 Dec 2011 15:18:03 +0000 Subject: [PATCH] Add more objects from a 1.5 install, including comments [#1390] git-svn-id: http://svn.osgeo.org/postgis/trunk@8476 b70326c6-7e19-0410-871a-916f4a2858ee --- utils/postgis_restore.pl | 319 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 319 insertions(+) diff --git a/utils/postgis_restore.pl b/utils/postgis_restore.pl index 889533769..19f83bdf6 100755 --- a/utils/postgis_restore.pl +++ b/utils/postgis_restore.pl @@ -400,6 +400,321 @@ CAST CAST (raster AS geometry) CAST CAST (text AS public.geometry) CAST CAST (topology.topogeometry AS geometry) CAST CAST (topology.topogeometry AS public.geometry) +COMMENT AGGREGATE st_accum(geometry) +COMMENT AGGREGATE st_collect(geometry) +COMMENT AGGREGATE st_extent3d(geometry) +COMMENT AGGREGATE st_extent(geometry) +COMMENT AGGREGATE st_makeline(geometry) +COMMENT AGGREGATE st_memunion(geometry) +COMMENT AGGREGATE st_polygonize(geometry) +COMMENT AGGREGATE st_union(geometry) +COMMENT FUNCTION addauth(text) +COMMENT FUNCTION addgeometrycolumn(charactervarying,charactervarying,charactervarying,charactervarying,integer,charactervarying,integer) +COMMENT FUNCTION addgeometrycolumn(charactervarying,charactervarying,charactervarying,integer,charactervarying,integer) +COMMENT FUNCTION addgeometrycolumn(charactervarying,charactervarying,integer,charactervarying,integer) +COMMENT FUNCTION box2d(geometry) +COMMENT FUNCTION box3d(geometry) +COMMENT FUNCTION checkauth(text,text) +COMMENT FUNCTION checkauth(text,text,text) +COMMENT FUNCTION disablelongtransactions() +COMMENT FUNCTION dropgeometrycolumn(charactervarying,charactervarying) +COMMENT FUNCTION dropgeometrycolumn(charactervarying,charactervarying,charactervarying) +COMMENT FUNCTION dropgeometrycolumn(charactervarying,charactervarying,charactervarying,charactervarying) +COMMENT FUNCTION dropgeometrytable(charactervarying) +COMMENT FUNCTION dropgeometrytable(charactervarying,charactervarying) +COMMENT FUNCTION dropgeometrytable(charactervarying,charactervarying,charactervarying) +COMMENT FUNCTION enablelongtransactions() +COMMENT FUNCTION find_srid(charactervarying,charactervarying,charactervarying) +COMMENT FUNCTION geometrytype(geometry) +COMMENT FUNCTION lockrow(text,text,text) +COMMENT FUNCTION lockrow(text,text,text,text,timestampwithouttimezone) +COMMENT FUNCTION lockrow(text,text,text,timestampwithouttimezone) +COMMENT FUNCTION populate_geometry_columns() +COMMENT FUNCTION populate_geometry_columns(tbl_oidoid) +COMMENT FUNCTION postgis_addbbox(geometry) +COMMENT FUNCTION postgis_dropbbox(geometry) +COMMENT FUNCTION postgis_full_version() +COMMENT FUNCTION postgis_geos_version() +COMMENT FUNCTION postgis_hasbbox(geometry) +COMMENT FUNCTION postgis_lib_build_date() +COMMENT FUNCTION postgis_lib_version() +COMMENT FUNCTION postgis_libxml_version() +COMMENT FUNCTION postgis_proj_version() +COMMENT FUNCTION postgis_scripts_build_date() +COMMENT FUNCTION postgis_scripts_installed() +COMMENT FUNCTION postgis_scripts_released() +COMMENT FUNCTION postgis_uses_stats() +COMMENT FUNCTION postgis_version() +COMMENT FUNCTION probe_geometry_columns() +COMMENT FUNCTION st_addmeasure(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_addpoint(geometry,geometry) +COMMENT FUNCTION st_addpoint(geometry,geometry,integer) +COMMENT FUNCTION st_affine(geometry,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_affine(geometry,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_area(geography) +COMMENT FUNCTION st_area(geography,boolean) +COMMENT FUNCTION st_area(geometry) +COMMENT FUNCTION st_asbinary(geography) +COMMENT FUNCTION st_asbinary(geometry) +COMMENT FUNCTION st_asbinary(geometry,text) +COMMENT FUNCTION st_asewkb(geometry) +COMMENT FUNCTION st_asewkb(geometry,text) +COMMENT FUNCTION st_asewkt(geometry) +COMMENT FUNCTION st_asgeojson(geography) +COMMENT FUNCTION st_asgeojson(geography,integer) +COMMENT FUNCTION st_asgeojson(geography,integer,integer) +COMMENT FUNCTION st_asgeojson(geometry) +COMMENT FUNCTION st_asgeojson(geometry,integer) +COMMENT FUNCTION st_asgeojson(geometry,integer,integer) +COMMENT FUNCTION st_asgeojson(integer,geography) +COMMENT FUNCTION st_asgeojson(integer,geography,integer) +COMMENT FUNCTION st_asgeojson(integer,geography,integer,integer) +COMMENT FUNCTION st_asgeojson(integer,geometry) +COMMENT FUNCTION st_asgeojson(integer,geometry,integer) +COMMENT FUNCTION st_asgeojson(integer,geometry,integer,integer) +COMMENT FUNCTION st_asgml(geography) +COMMENT FUNCTION st_asgml(geography,integer) +COMMENT FUNCTION st_asgml(geometry) +COMMENT FUNCTION st_asgml(geometry,integer) +COMMENT FUNCTION st_asgml(integer,geography) +COMMENT FUNCTION st_asgml(integer,geography,integer) +COMMENT FUNCTION st_asgml(integer,geography,integer,integer) +COMMENT FUNCTION st_asgml(integer,geometry) +COMMENT FUNCTION st_asgml(integer,geometry,integer) +COMMENT FUNCTION st_asgml(integer,geometry,integer,integer) +COMMENT FUNCTION st_ashexewkb(geometry) +COMMENT FUNCTION st_ashexewkb(geometry,text) +COMMENT FUNCTION st_askml(geography) +COMMENT FUNCTION st_askml(geography,integer) +COMMENT FUNCTION st_askml(geometry) +COMMENT FUNCTION st_askml(geometry,integer) +COMMENT FUNCTION st_askml(integer,geography) +COMMENT FUNCTION st_askml(integer,geography,integer) +COMMENT FUNCTION st_askml(integer,geometry) +COMMENT FUNCTION st_askml(integer,geometry,integer) +COMMENT FUNCTION st_assvg(geography) +COMMENT FUNCTION st_assvg(geography,integer) +COMMENT FUNCTION st_assvg(geography,integer,integer) +COMMENT FUNCTION st_assvg(geometry) +COMMENT FUNCTION st_assvg(geometry,integer) +COMMENT FUNCTION st_assvg(geometry,integer,integer) +COMMENT FUNCTION st_astext(geography) +COMMENT FUNCTION st_astext(geometry) +COMMENT FUNCTION st_azimuth(geometry,geometry) +COMMENT FUNCTION st_bdmpolyfromtext(text,integer) +COMMENT FUNCTION st_bdpolyfromtext(text,integer) +COMMENT FUNCTION st_boundary(geometry) +COMMENT FUNCTION st_buffer(geography,doubleprecision) +COMMENT FUNCTION st_buffer(geometry,doubleprecision) +COMMENT FUNCTION st_buffer(geometry,doubleprecision,integer) +COMMENT FUNCTION st_buffer(geometry,doubleprecision,text) +COMMENT FUNCTION st_buildarea(geometry) +COMMENT FUNCTION st_centroid(geometry) +COMMENT FUNCTION st_closestpoint(geometry,geometry) +COMMENT FUNCTION st_collect(geometry[]) +COMMENT FUNCTION st_collect(geometry,geometry) +COMMENT FUNCTION st_collectionextract(geometry,integer) +COMMENT FUNCTION st_contains(geometry,geometry) +COMMENT FUNCTION st_containsproperly(geometry,geometry) +COMMENT FUNCTION st_convexhull(geometry) +COMMENT FUNCTION st_coorddim(geometry) +COMMENT FUNCTION st_coveredby(geography,geography) +COMMENT FUNCTION st_coveredby(geometry,geometry) +COMMENT FUNCTION st_covers(geography,geography) +COMMENT FUNCTION st_covers(geometry,geometry) +COMMENT FUNCTION st_crosses(geometry,geometry) +COMMENT FUNCTION st_curvetoline(geometry) +COMMENT FUNCTION st_curvetoline(geometry,integer) +COMMENT FUNCTION st_dfullywithin(geometry,geometry,doubleprecision) +COMMENT FUNCTION st_difference(geometry,geometry) +COMMENT FUNCTION st_dimension(geometry) +COMMENT FUNCTION st_disjoint(geometry,geometry) +COMMENT FUNCTION st_distance(geography,geography) +COMMENT FUNCTION st_distance(geography,geography,boolean) +COMMENT FUNCTION st_distance(geometry,geometry) +COMMENT FUNCTION st_distance_sphere(geometry,geometry) +COMMENT FUNCTION st_distance_spheroid(geometry,geometry,spheroid) +COMMENT FUNCTION st_dump(geometry) +COMMENT FUNCTION st_dumppoints(geometry) +COMMENT FUNCTION st_dumprings(geometry) +COMMENT FUNCTION st_dwithin(geography,geography,doubleprecision) +COMMENT FUNCTION st_dwithin(geography,geography,doubleprecision,boolean) +COMMENT FUNCTION st_dwithin(geometry,geometry,doubleprecision) +COMMENT FUNCTION st_endpoint(geometry) +COMMENT FUNCTION st_envelope(geometry) +COMMENT FUNCTION st_equals(geometry,geometry) +COMMENT FUNCTION st_estimated_extent(text,text) +COMMENT FUNCTION st_estimated_extent(text,text,text) +COMMENT FUNCTION st_expand(box2d,doubleprecision) +COMMENT FUNCTION st_expand(box3d,doubleprecision) +COMMENT FUNCTION st_expand(geometry,doubleprecision) +COMMENT FUNCTION st_exteriorring(geometry) +COMMENT FUNCTION st_force_2d(geometry) +COMMENT FUNCTION st_force_3d(geometry) +COMMENT FUNCTION st_force_3dm(geometry) +COMMENT FUNCTION st_force_3dz(geometry) +COMMENT FUNCTION st_force_4d(geometry) +COMMENT FUNCTION st_force_collection(geometry) +COMMENT FUNCTION st_forcerhr(geometry) +COMMENT FUNCTION st_geogfromtext(text) +COMMENT FUNCTION st_geogfromwkb(bytea) +COMMENT FUNCTION st_geographyfromtext(text) +COMMENT FUNCTION st_geohash(geometry) +COMMENT FUNCTION st_geohash(geometry,integer) +COMMENT FUNCTION st_geomcollfromtext(text) +COMMENT FUNCTION st_geomcollfromtext(text,integer) +COMMENT FUNCTION st_geometryfromtext(text) +COMMENT FUNCTION st_geometryfromtext(text,integer) +COMMENT FUNCTION st_geometryn(geometry,integer) +COMMENT FUNCTION st_geometrytype(geometry) +COMMENT FUNCTION st_geomfromewkb(bytea) +COMMENT FUNCTION st_geomfromewkt(text) +COMMENT FUNCTION st_geomfromgml(text) +COMMENT FUNCTION st_geomfromkml(text) +COMMENT FUNCTION st_geomfromtext(text) +COMMENT FUNCTION st_geomfromtext(text,integer) +COMMENT FUNCTION st_geomfromwkb(bytea) +COMMENT FUNCTION st_geomfromwkb(bytea,integer) +COMMENT FUNCTION st_gmltosql(text) +COMMENT FUNCTION st_hasarc(geometry) +COMMENT FUNCTION st_hausdorffdistance(geometry,geometry) +COMMENT FUNCTION st_hausdorffdistance(geometry,geometry,doubleprecision) +COMMENT FUNCTION st_interiorringn(geometry,integer) +COMMENT FUNCTION st_intersection(geography,geography) +COMMENT FUNCTION st_intersection(geometry,geometry) +COMMENT FUNCTION st_intersects(geography,geography) +COMMENT FUNCTION st_intersects(geometry,geometry) +COMMENT FUNCTION st_isclosed(geometry) +COMMENT FUNCTION st_isempty(geometry) +COMMENT FUNCTION st_isring(geometry) +COMMENT FUNCTION st_issimple(geometry) +COMMENT FUNCTION st_isvalid(geometry) +COMMENT FUNCTION st_isvalidreason(geometry) +COMMENT FUNCTION st_length2d(geometry) +COMMENT FUNCTION st_length2d_spheroid(geometry,spheroid) +COMMENT FUNCTION st_length3d(geometry) +COMMENT FUNCTION st_length3d_spheroid(geometry,spheroid) +COMMENT FUNCTION st_length(geography) +COMMENT FUNCTION st_length(geography,boolean) +COMMENT FUNCTION st_length(geometry) +COMMENT FUNCTION st_length_spheroid(geometry,spheroid) +COMMENT FUNCTION st_linecrossingdirection(geometry,geometry) +COMMENT FUNCTION st_linefrommultipoint(geometry) +COMMENT FUNCTION st_linefromtext(text) +COMMENT FUNCTION st_linefromtext(text,integer) +COMMENT FUNCTION st_linefromwkb(bytea) +COMMENT FUNCTION st_linefromwkb(bytea,integer) +COMMENT FUNCTION st_line_interpolate_point(geometry,doubleprecision) +COMMENT FUNCTION st_line_locate_point(geometry,geometry) +COMMENT FUNCTION st_linemerge(geometry) +COMMENT FUNCTION st_linestringfromwkb(bytea) +COMMENT FUNCTION st_linestringfromwkb(bytea,integer) +COMMENT FUNCTION st_line_substring(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_linetocurve(geometry) +COMMENT FUNCTION st_locate_along_measure(geometry,doubleprecision) +COMMENT FUNCTION st_locatebetweenelevations(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_locate_between_measures(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_longestline(geometry,geometry) +COMMENT FUNCTION st_makebox2d(geometry,geometry) +COMMENT FUNCTION st_makebox3d(geometry,geometry) +COMMENT FUNCTION st_makeenvelope(doubleprecision,doubleprecision,doubleprecision,doubleprecision,integer) +COMMENT FUNCTION st_makeline(geometry[]) +COMMENT FUNCTION st_makeline(geometry,geometry) +COMMENT FUNCTION st_makepoint(doubleprecision,doubleprecision) +COMMENT FUNCTION st_makepoint(doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_makepoint(doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_makepointm(doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_makepolygon(geometry) +COMMENT FUNCTION st_makepolygon(geometry,geometry[]) +COMMENT FUNCTION st_maxdistance(geometry,geometry) +COMMENT FUNCTION st_mem_size(geometry) +COMMENT FUNCTION st_m(geometry) +COMMENT FUNCTION st_minimumboundingcircle(geometry) +COMMENT FUNCTION st_minimumboundingcircle(inputgeomgeometry,segs_per_quarterinteger) +COMMENT FUNCTION st_mlinefromtext(text) +COMMENT FUNCTION st_mlinefromtext(text,integer) +COMMENT FUNCTION st_mpointfromtext(text) +COMMENT FUNCTION st_mpointfromtext(text,integer) +COMMENT FUNCTION st_mpolyfromtext(text) +COMMENT FUNCTION st_mpolyfromtext(text,integer) +COMMENT FUNCTION st_multi(geometry) +COMMENT FUNCTION st_ndims(geometry) +COMMENT FUNCTION st_npoints(geometry) +COMMENT FUNCTION st_nrings(geometry) +COMMENT FUNCTION st_numgeometries(geometry) +COMMENT FUNCTION st_numinteriorring(geometry) +COMMENT FUNCTION st_numinteriorrings(geometry) +COMMENT FUNCTION st_numpoints(geometry) +COMMENT FUNCTION st_orderingequals(geometry,geometry) +COMMENT FUNCTION st_overlaps(geometry,geometry) +COMMENT FUNCTION st_perimeter2d(geometry) +COMMENT FUNCTION st_perimeter3d(geometry) +COMMENT FUNCTION st_perimeter(geometry) +COMMENT FUNCTION st_point(doubleprecision,doubleprecision) +COMMENT FUNCTION st_pointfromtext(text) +COMMENT FUNCTION st_pointfromtext(text,integer) +COMMENT FUNCTION st_point_inside_circle(geometry,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_pointn(geometry,integer) +COMMENT FUNCTION st_pointonsurface(geometry) +COMMENT FUNCTION st_polygonfromtext(text) +COMMENT FUNCTION st_polygonfromtext(text,integer) +COMMENT FUNCTION st_polygon(geometry,integer) +COMMENT FUNCTION st_polygonize(geometry[]) +COMMENT FUNCTION st_relate(geometry,geometry) +COMMENT FUNCTION st_relate(geometry,geometry,text) +COMMENT FUNCTION st_removepoint(geometry,integer) +COMMENT FUNCTION st_reverse(geometry) +COMMENT FUNCTION st_rotate(geometry,doubleprecision) +COMMENT FUNCTION st_rotatex(geometry,doubleprecision) +COMMENT FUNCTION st_rotatey(geometry,doubleprecision) +COMMENT FUNCTION st_rotatez(geometry,doubleprecision) +COMMENT FUNCTION st_scale(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_scale(geometry,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_segmentize(geometry,doubleprecision) +COMMENT FUNCTION st_setpoint(geometry,integer,geometry) +COMMENT FUNCTION st_setsrid(geometry,integer) +COMMENT FUNCTION st_shift_longitude(geometry) +COMMENT FUNCTION st_shortestline(geometry,geometry) +COMMENT FUNCTION st_simplify(geometry,doubleprecision) +COMMENT FUNCTION st_simplifypreservetopology(geometry,doubleprecision) +COMMENT FUNCTION st_snaptogrid(geometry,doubleprecision) +COMMENT FUNCTION st_snaptogrid(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_snaptogrid(geometry,doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_snaptogrid(geometry,geometry,doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_srid(geometry) +COMMENT FUNCTION st_startpoint(geometry) +COMMENT FUNCTION st_summary(geometry) +COMMENT FUNCTION st_symdifference(geometry,geometry) +COMMENT FUNCTION st_touches(geometry,geometry) +COMMENT FUNCTION st_transform(geometry,integer) +COMMENT FUNCTION st_translate(geometry,doubleprecision,doubleprecision) +COMMENT FUNCTION st_translate(geometry,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_transscale(geometry,doubleprecision,doubleprecision,doubleprecision,doubleprecision) +COMMENT FUNCTION st_union(geometry[]) +COMMENT FUNCTION st_union(geometry,geometry) +COMMENT FUNCTION st_within(geometry,geometry) +COMMENT FUNCTION st_wkbtosql(bytea) +COMMENT FUNCTION st_wkttosql(text) +COMMENT FUNCTION st_x(geometry) +COMMENT FUNCTION st_xmax(box3d) +COMMENT FUNCTION st_xmin(box3d) +COMMENT FUNCTION st_y(geometry) +COMMENT FUNCTION st_ymax(box3d) +COMMENT FUNCTION st_ymin(box3d) +COMMENT FUNCTION st_z(geometry) +COMMENT FUNCTION st_zmax(box3d) +COMMENT FUNCTION st_zmflag(geometry) +COMMENT FUNCTION st_zmin(box3d) +COMMENT FUNCTION unlockrows(text) +COMMENT FUNCTION updategeometrysrid(charactervarying,charactervarying,charactervarying,charactervarying,integer) +COMMENT FUNCTION updategeometrysrid(charactervarying,charactervarying,charactervarying,integer) +COMMENT FUNCTION updategeometrysrid(charactervarying,charactervarying,integer) +COMMENT TYPE box2d +COMMENT TYPE box3d +COMMENT TYPE box3d_extent +COMMENT TYPE geography +COMMENT TYPE geometry +COMMENT TYPE geometry_dump CONSTRAINT geometry_columns_pk CONSTRAINT layer_pkey CONSTRAINT layer_schema_name_key @@ -665,6 +980,7 @@ FUNCTION geography(geography, integer, boolean) FUNCTION geography(geometry) FUNCTION geography_gist_compress(internal) FUNCTION geography_gist_consistent(internal, geography, integer) +FUNCTION geography_gist_consistent(internal,geometry,integer) FUNCTION geography_gist_decompress(internal) FUNCTION geography_gist_join_selectivity(internal, oid, internal, smallint) FUNCTION geography_gist_penalty(internal, internal, internal) @@ -713,6 +1029,7 @@ FUNCTION geometry_gist_decompress_2d(internal) FUNCTION geometry_gist_decompress_nd(internal) FUNCTION geometry_gist_distance_2d(internal, geometry, integer) FUNCTION geometry_gist_joinsel_2d(internal, oid, internal, smallint) +FUNCTION geometry_gist_joinsel(internal,oid,internal,smallint) FUNCTION geometry_gist_penalty_2d(internal, internal, internal) FUNCTION geometry_gist_penalty_nd(internal, internal, internal) FUNCTION geometry_gist_picksplit_2d(internal, internal) @@ -720,6 +1037,7 @@ FUNCTION geometry_gist_picksplit_nd(internal, internal) FUNCTION geometry_gist_same_2d(geometry, geometry, internal) FUNCTION geometry_gist_same_nd(geometry, geometry, internal) FUNCTION geometry_gist_sel_2d(internal, oid, internal, integer) +FUNCTION geometry_gist_sel(internal,oid,internal,integer) FUNCTION geometry_gist_union_2d(bytea, internal) FUNCTION geometry_gist_union_nd(bytea, internal) FUNCTION geometry_gt(geometry, geometry) @@ -1128,6 +1446,7 @@ FUNCTION st_asgml(integer, geography, integer, integer, text) FUNCTION st_asgml(integer, geometry) FUNCTION _st_asgml(integer, geometry, integer) FUNCTION st_asgml(integer, geometry, integer) +FUNCTION _st_asgml(integer,geometry,integer,integer) FUNCTION st_asgml(integer, geometry, integer, integer) FUNCTION _st_asgml(integer, geometry, integer, integer, text) FUNCTION st_asgml(integer, geometry, integer, integer, text) -- 2.40.0