Revision 3284
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 4395 | 4395 |
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: TRIGGER; Schema: public; Owner: - |
| 4396 | 4396 |
-- |
| 4397 | 4397 |
|
| 4398 |
CREATE TRIGGER taxondetermination_taxonoccurrence_id_fkey BEFORE INSERT OR UPDATE ON taxondetermination FOR EACH ROW EXECUTE PROCEDURE taxondetermination_taxonoccurrence_id_fkey();
|
|
| 4398 |
CREATE TRIGGER taxondetermination_taxonoccurrence_id_fkey AFTER INSERT OR UPDATE ON taxondetermination FOR EACH ROW EXECUTE PROCEDURE taxondetermination_taxonoccurrence_id_fkey();
|
|
| 4399 | 4399 |
|
| 4400 | 4400 |
|
| 4401 | 4401 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Fixed bug where taxondetermination_taxonoccurrence_id_fkey trigger was applied before the NOT NULL constraint on taxonoccurrence_id was checked, causing the trigger to fail on NULL taxonoccurrence_ids, by making it an AFTER trigger. (An AFTER trigger will still roll back the entire insert if it fails, even though it runs after the insert itself.)