/schemas/vegbien.sql - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 5511

schemas/vegbien.sql: *_update_ancestors(): Telling immediate children to update their ancestors lists: Exclude self to avoid infinite recursion

         SET place_id = place_id -- need at least one SET statement
         -- Add COALESCE() to enable using place_unique index for lookup
         WHERE COALESCE(parent_id, 2147483647) = new.place_id
         AND place_id != new.place_id -- avoid infinite recursion
+        ;
         /* Note: We don't need an ON DELETE trigger to update the descendants'
-...
         SET taxonconcept_id = taxonconcept_id -- need at least one SET statement
         -- Add COALESCE() to enable using taxonconcept_unique index for lookup
         WHERE COALESCE(parent_id, 2147483647) = new.taxonconcept_id
         AND taxonconcept_id != new.taxonconcept_id -- avoid infinite recursion
+        ;
         /* Note: We don't need an ON DELETE trigger to update the descendants'

Also available in: Unified diff