使用EF連接postgreSQL 后，insert資料發現需要回傳Id
但是設定觸發器后，主表卻增加了兩條資料
CREATE OR REPLACE FUNCTION "dbo"."measurement_insert_trigger"()
RETURNS "pg_catalog"."trigger" AS $BODY$
DECLARE
id integer;
BEGIN
IF ( NEW."ReceivedTimestamp" >= DATE '2020-01-01' AND
NEW."ReceivedTimestamp" < DATE '2020-06-30' ) THEN
INSERT INTO dbo.orders_202001 VALUES (NEW.*);
ELSIF ( NEW."ReceivedTimestamp" >= DATE '2020-07-01' AND
NEW."ReceivedTimestamp" < DATE '2020-12-31' ) THEN
INSERT INTO dbo.orders_202002 VALUES (NEW.*);
ELSE
RAISE EXCEPTION 'Date out of range. Fix the measurement_insert_trigger() function!';
END IF;
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
CREATE TRIGGER insert_measurement_trigger
BEFORE INSERT ON dbo."Orders"
FOR EACH ROW EXECUTE PROCEDURE dbo.measurement_insert_trigger();
上述是觸發器
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/66554.html
標籤：C#
上一篇：串口一次最大能接收多少位元組