Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 824:6e5a0edba363
Fixed database function.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 18 Dec 2015 17:32:30 +0100 |
| parents | 2b0d99fbeecc |
| children | 47dc3c4e42dd |
comparison
equal
deleted
inserted
replaced
| 813:5155b0b375cd | 824:6e5a0edba363 |
|---|---|
| 150 BEGIN | 150 BEGIN |
| 151 RAISE NOTICE 'probe is %',NEW.id; | 151 RAISE NOTICE 'probe is %',NEW.id; |
| 152 NEW.tree_modified = now(); | 152 NEW.tree_modified = now(); |
| 153 RAISE NOTICE 'updating other rows'; | 153 RAISE NOTICE 'updating other rows'; |
| 154 UPDATE land.messung SET tree_modified = now() WHERE probe_id = NEW.id; | 154 UPDATE land.messung SET tree_modified = now() WHERE probe_id = NEW.id; |
| 155 UPDATE land.ort SET tree_modified = now() WHERE probe_id = NEW.id; | 155 UPDATE land.ortszuordnung SET tree_modified = now() WHERE probe_id = NEW.id; |
| 156 UPDATE land.zusatz_wert SET tree_modified = now() WHERE probe_id = NEW.id; | 156 UPDATE land.zusatz_wert SET tree_modified = now() WHERE probe_id = NEW.id; |
| 157 RETURN NEW; | 157 RETURN NEW; |
| 158 END; | 158 END; |
| 159 $$; | 159 $$; |
| 160 | 160 |