DEFINITIONS

Definitions More Info.
Definition ID1
TitlePOSTGRESQL
CategoryNOTES
Definitioncreate trigger function
Definition Description-- When we create function in 9.1, choose all command line then, execute script.


-- Create Log table

CREATE TABLE "DBACHECKDB"."AddressIDLog" (
"AddressID" int8 NULL,
"RoleName" varchar(100) NULL,
"RecordDate" timestamp NULL
);


1- FIRST WE CREATE TRIGGER FUNCTION

CREATE FUNCTION "DBACHECKDB"."GetAddressID"()
RETURNS trigger
LANGUAGE 'plpgsql'
COST 100
VOLATILE
AS $BODY$
BEGIN
IF TG_OP = 'INSERT' THEN

INSERT INTO "DBACHECKDB"."AddressIDLog" ("AddressID","RoleName","RecordDate")
SELECT NEW."ID",current_user,now();
END IF;
RETURN NULL;
END
$BODY$;

2- THEN WE CREATE TRIGGER ON TABLE

CREATE
TRIGGER "GetAddressIDForOrphanRecord" AFTER INSERT
ON
"Address" FOR EACH ROW EXECUTE PROCEDURE "DBACHECKDB"."GetAddressID"();
RecordBycunay
Record Date10-09-2018 09:50:21
Düzenle
Kopyala
Sil