comparison gnv-artifacts/doc/conf/queries.properties @ 844:74608c12b4fe

Added Query for the CacheCleaner that it use to determin which Tables has been updated. gnv-artifacts/trunk@960 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 20 Apr 2010 12:53:00 +0000
parents 8065295ae255
children 3fbabd4803d7
comparison
equal deleted inserted replaced
843:4bae3081eb1e 844:74608c12b4fe
1400 geometry_type = select geometry_type \ 1400 geometry_type = select geometry_type \
1401 from sde.geometry_columns \ 1401 from sde.geometry_columns \
1402 where f_table_schema = '?' and \ 1402 where f_table_schema = '?' and \
1403 f_table_name = '?' and \ 1403 f_table_name = '?' and \
1404 f_geometry_column='SHAPE' 1404 f_geometry_column='SHAPE'
1405
1406 updated_tables = SELECT FULLTABLENAME \
1407 FROM MEDIAN.LASTUPDATED \
1408 WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS')

http://dive4elements.wald.intevation.org