D 2019-07-26T20:54:51.366
J foundin 4.30a
J icomment The\sschema\sresults\sshould\sbe\sthe\ssame\swhen\susing\sAddGeometryColumn\svs\sRecoverGeometryColumn\r\n\r\nThe\sschema\sresulting\sfrom\sAddGeometryColumn\swill\sbe\smissing\striggers\r\n\r\nThe\sfollowing\striggers\swill\sbe\smissing.\sall\sother\sparts\sof\sthe\s`.schema`\soutput\sare\sthe\ssame:\r\n\r\n<pre>\r\nCREATE\sTRIGGER\s"ggi_geotable_LOCATION"\sBEFORE\sINSERT\sON\s"geotable"\r\nFOR\sEACH\sROW\sBEGIN\r\nSELECT\sRAISE(ROLLBACK,\s'geotable.LOCATION\sviolates\sGeometry\sconstraint\s[geom-type\sor\sSRID\snot\sallowed]')\r\nWHERE\s(SELECT\sgeometry_type\sFROM\sgeometry_columns\r\nWHERE\sLower(f_table_name)\s=\sLower('geotable')\sAND\sLower(f_geometry_column)\s=\sLower('LOCATION')\r\nAND\sGeometryConstraints(NEW."LOCATION",\sgeometry_type,\ssrid)\s=\s1)\sIS\sNULL;\r\nEND;\r\nCREATE\sTRIGGER\s"ggu_geotable_LOCATION"\sBEFORE\sUPDATE\sOF\s"LOCATION"\sON\s"geotable"\r\nFOR\sEACH\sROW\sBEGIN\r\nSELECT\sRAISE(ROLLBACK,\s'geotable.LOCATION\sviolates\sGeometry\sconstraint\s[geom-type\sor\sSRID\snot\sallowed]')\r\nWHERE\s(SELECT\sgeometry_type\sFROM\sgeometry_columns\r\nWHERE\sLower(f_table_name)\s=\sLower('geotable')\sAND\sLower(f_geometry_column)\s=\sLower('LOCATION')\r\nAND\sGeometryConstraints(NEW."LOCATION",\sgeometry_type,\ssrid)\s=\s1)\sIS\sNULL;\r\nEND;\r\nCREATE\sTRIGGER\s"tmd_geotable_LOCATION"\sAFTER\sDELETE\sON\s"geotable"\r\nFOR\sEACH\sROW\sBEGIN\r\nUPDATE\sgeometry_columns_time\sSET\slast_delete\s=\sstrftime('%Y-%m-%dT%H:%M:%fZ',\s'now')\r\nWHERE\sLower(f_table_name)\s=\sLower('geotable')\sAND\sLower(f_geometry_column)\s=\sLower('LOCATION');\r\nEND;\r\nCREATE\sTRIGGER\s"tmi_geotable_LOCATION"\sAFTER\sINSERT\sON\s"geotable"\r\nFOR\sEACH\sROW\sBEGIN\r\nUPDATE\sgeometry_columns_time\sSET\slast_insert\s=\sstrftime('%Y-%m-%dT%H:%M:%fZ',\s'now')\r\nWHERE\sLower(f_table_name)\s=\sLower('geotable')\sAND\sLower(f_geometry_column)\s=\sLower('LOCATION');\r\nEND;\r\nCREATE\sTRIGGER\s"tmu_geotable_LOCATION"\sAFTER\sUPDATE\sON\s"geotable"\r\nFOR\sEACH\sROW\sBEGIN\r\nUPDATE\sgeometry_columns_time\sSET\slast_update\s=\sstrftime('%Y-%m-%dT%H:%M:%fZ',\s'now')\r\nWHERE\sLower(f_table_name)\s=\sLower('geotable')\sAND\sLower(f_geometry_column)\s=\sLower('LOCATION');\r\nEND;</pre>
J login anonymous
J mimetype text/x-fossil-wiki
J private_contact 7a2f5437d87f2e69c2ff6f309142b24fb6e56321
J severity Important
J status Open
J title AddGeometryColumn\smissing\sSRID\strigger
J type Code_Defect
K 1b33d171d1dea88cd14da738bdf429b423707005
U anonymous
Z 1008d4d6316d71ec3013c7d7d7132d11