CODEWITHSUNDEEP
mysqlpostgresql
snirali
snirali

Reputation: 139

create trigger in postgreSQL

I am new to PostgreSQL and I am migrating to it from MySQL.Trying to creating Trigger in that.But can't done with it.

This is my MySQL Query.

  delimiter $$
  create trigger delVPNProfile before delete on VPN_Profile_List for each row begin update userinfo set Profile_ID='-1' where Profile_ID=old.Profile_ID; end;$$
  delimiter ;

My PostgreSQL Query is like this.

  $ CREATE FUNCTION make_default_privileges() returns trigger as $$
  begin
  update userinfo set Profile_ID='-1' where Profile_ID=old.Profile_ID;
  end;
  $$ language plpgsql;
  create trigger delVPNProfile before delete on VPN_Profile_List for each row begin EXECUTE PROCEDURE make_default_privileges();

Upvotes: 1

Views: 359

Answers (1)

Mesbah Gueffaf
Mesbah Gueffaf

Reputation: 558

CREATE FUNCTION make_default_privileges() RETURNS trigger AS      $make_default_privileges$
old_id          integer;
BEGIN
old_id=OLD.Profile_ID;
update userinfo set Profile_ID='-1' where Profile_ID=old_id;
RETURN OLD;
END;
   $make_default_privileges$ LANGUAGE plpgsql;

CREATE TRIGGER delVPNProfile before delete on VPN_Profile_List
FOR EACH ROW EXECUTE PROCEDURE make_default_privileges();

Upvotes: 1

Related Questions