diff db_schema/lada_schema.sql @ 1168:cd9bf2430eef

Let the database enforce,too, what rev 46db98d060ae introduced.
author Tom Gottfried <tom@intevation.de>
date Wed, 09 Nov 2016 17:24:49 +0100
parents 84ff77bba9b0
children 4ee336c65ab3
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Wed Nov 09 16:32:29 2016 +0100
+++ b/db_schema/lada_schema.sql	Wed Nov 09 17:24:49 2016 +0100
@@ -278,7 +278,8 @@
     ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ,
     ortszusatztext character varying(100),
     letzte_aenderung timestamp without time zone DEFAULT now(),
-    tree_modified timestamp without time zone DEFAULT now()
+    tree_modified timestamp without time zone DEFAULT now(),
+    EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E')
 );
 CREATE TRIGGER letzte_aenderung_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung();
 CREATE TRIGGER tree_modified_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_tree_modified();
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)