EF postgre分区问题

[andyjewels]

使用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();

上述是触发器