Removed steward udate table.

SimonGoring · SimonGoring · commit 5973e295587d · 2023-03-16T12:48:42.000-07:00
diff --git a/function/ts/insertdatasettaxonnotes.sql b/function/ts/insertdatasettaxonnotes.sql
@@ -4,16 +4,4 @@ CREATE OR REPLACE FUNCTION ts.insertdatasettaxonnotes(_datasetid integer, _taxon
 AS $function$
   INSERT INTO ndb.datasettaxonnotes (datasetid, taxonid, contactid, date, notes)
   VALUES      (_datasetid, _taxonid, _contactid, TO_DATE(_date, 'YYYY-MM-DD'), _notes);
-
-  WITH updval AS (
-    SELECT _contactid AS contactid,
-           'datasettaxonnotes' AS tablename,
-           _datasetid AS pk1,
-           _taxonid AS pk2,
-           'insert' AS operation
-    WHERE _update
-  )
-  INSERT INTO ti.stewardupdates(contactid, tablename, pk1, pk2, operation)
-  SELECT * FROM updval;
-
 $function$
