# SOME DESCRIPTIVE TITLE. # FIRST AUTHOR , YEAR. # #, fuzzy msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: http://bugs.kde.org\n" "POT-Creation-Date: 2017-01-28 07:02+0000\n" "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" "Last-Translator: FULL NAME \n" "Language-Team: LANGUAGE \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" #. Tag: title #: reference_exception.xml:3 #, no-c-format msgid "Exceptional Functions" msgstr "" #. Tag: para #: reference_exception.xml:4 #, no-c-format msgid "" "These functions are rarely used functions that should only be used if your " "data is corrupted in someway. They are used for troubleshooting corruption " "and also fixing things that should under normal circumstances, never happen." msgstr "" #. Tag: refname #: reference_exception.xml:9 #, no-c-format msgid "PostGIS_AddBBox" msgstr "" #. Tag: refpurpose #: reference_exception.xml:11 #, no-c-format msgid "Add bounding box to the geometry." msgstr "" #. Tag: funcprototype #: reference_exception.xml:16 #, no-c-format msgid "" "geometry PostGIS_AddBBox " "geometry geomA" msgstr "" #. Tag: title #: reference_exception.xml:24 reference_exception.xml:70 #: reference_exception.xml:119 #, no-c-format msgid "Description" msgstr "" #. Tag: para #: reference_exception.xml:26 #, no-c-format msgid "" "Add bounding box to the geometry. This would make bounding box based queries " "faster, but will increase the size of the geometry." msgstr "" #. Tag: para #: reference_exception.xml:31 #, no-c-format msgid "" "Bounding boxes are automatically added to geometries so in general this is " "not needed unless the generated bounding box somehow becomes corrupted or " "you have an old install that is lacking bounding boxes. Then you need to " "drop the old and readd." msgstr "" #. Tag: para #: reference_exception.xml:35 reference_exception.xml:83 #: reference_exception.xml:124 #, no-c-format msgid "&curve_support;" msgstr "" #. Tag: title #: reference_exception.xml:40 reference_exception.xml:88 #: reference_exception.xml:129 #, no-c-format msgid "Examples" msgstr "" #. Tag: programlisting #: reference_exception.xml:42 #, no-c-format msgid "" "UPDATE sometable\n" " SET the_geom = PostGIS_AddBBox(the_geom)\n" " WHERE PostGIS_HasBBox(the_geom) = false;" msgstr "" #. Tag: title #: reference_exception.xml:47 reference_exception.xml:95 #: reference_exception.xml:136 #, no-c-format msgid "See Also" msgstr "" #. Tag: para #: reference_exception.xml:49 #, no-c-format msgid ", " msgstr "" #. Tag: refname #: reference_exception.xml:55 #, no-c-format msgid "PostGIS_DropBBox" msgstr "" #. Tag: refpurpose #: reference_exception.xml:57 #, no-c-format msgid "Drop the bounding box cache from the geometry." msgstr "" #. Tag: funcprototype #: reference_exception.xml:62 #, no-c-format msgid "" "geometry PostGIS_DropBBox " "geometry geomA" msgstr "" #. Tag: para #: reference_exception.xml:72 #, no-c-format msgid "" "Drop the bounding box cache from the geometry. This reduces geometry size, " "but makes bounding-box based queries slower. It is also used to drop a " "corrupt bounding box. A tale-tell sign of a corrupt cached bounding box is " "when your ST_Intersects and other relation queries leave out geometries that " "rightfully should return true." msgstr "" #. Tag: para #: reference_exception.xml:77 #, no-c-format msgid "" "Bounding boxes are automatically added to geometries and improve speed of " "queries so in general this is not needed unless the generated bounding box " "somehow becomes corrupted or you have an old install that is lacking " "bounding boxes. Then you need to drop the old and readd. This kind of " "corruption has been observed in 8.3-8.3.6 series whereby cached bboxes were " "not always recalculated when a geometry changed and upgrading to a newer " "version without a dump reload will not correct already corrupted boxes. So " "one can manually correct using below and readd the bbox or do a dump reload." msgstr "" #. Tag: programlisting #: reference_exception.xml:90 #, no-c-format msgid "" "--This example drops bounding boxes where the cached box is not correct\n" " --The force to ST_AsBinary before applying Box2D " "forces a recalculation of the box, and Box2D applied to the table geometry " "always\n" " -- returns the cached bounding box.\n" " UPDATE sometable\n" " SET the_geom = PostGIS_DropBBox(the_geom)\n" " WHERE Not (Box2D(ST_AsBinary(the_geom)) = Box2D(the_geom));\n" "\n" " UPDATE sometable\n" " SET the_geom = PostGIS_AddBBox(the_geom)\n" " WHERE Not PostGIS_HasBBOX(the_geom);" msgstr "" #. Tag: para #: reference_exception.xml:97 #, no-c-format msgid ", , " msgstr "" #. Tag: refname #: reference_exception.xml:104 #, no-c-format msgid "PostGIS_HasBBox" msgstr "" #. Tag: refpurpose #: reference_exception.xml:106 #, no-c-format msgid "Returns TRUE if the bbox of this geometry is cached, FALSE otherwise." msgstr "" #. Tag: funcprototype #: reference_exception.xml:111 #, no-c-format msgid "" "boolean PostGIS_HasBBox " "geometry geomA" msgstr "" #. Tag: para #: reference_exception.xml:121 #, no-c-format msgid "" "Returns TRUE if the bbox of this geometry is cached, FALSE otherwise. Use " " and " "to control caching." msgstr "" #. Tag: programlisting #: reference_exception.xml:131 #, no-c-format msgid "" "SELECT the_geom\n" "FROM sometable WHERE PostGIS_HasBBox(the_geom) = false;" msgstr "" #. Tag: para #: reference_exception.xml:138 #, no-c-format msgid ", " msgstr ""