CREATE OR REPLACE FUNCTION mm_users__islemler() RETURNS trigger
language plpgsql
as
$$
DECLARE
kayit_old RECORD; kayit_new RECORD; payload JSON;
BEGIN
IF (TG_OP = 'INSERT') THEN
kayit_old = NULL;
kayit_new = NEW;
ELSEIF (TG_OP = 'UPDATE') THEN
kayit_old = OLD;
kayit_new = NEW;
ELSEIF (TG_OP = 'DELETE') THEN
kayit_old = OLD;
kayit_new = NULL;
END IF;
payload = json_build_object('table', TG_TABLE_NAME, 'action', TG_OP, 'data', row_to_json(kayit_new), 'old_data', row_to_json(kayit_old));
PERFORM pg_notify('mm_users', payload::text); RETURN NULL;
$$;
create trigger mm_users__islemler_bilgi
after insert or update or delete
on mm_users
for each row
execute procedure mm_users__islemler();
PostgreSQL
hakkında diğer konular