DEFINITIONS
Definitions More Info.
Definition ID
1
Title
POSTGRESQL
Category
NOTES
Definition
create 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"();
RecordBy
cunay
Record Date
10-09-2018 09:50:21
Düzenle
Kopyala
Sil