CREATE TRIGGER check_add_reclayer
  BEFORE INSERT OR UPDATE OR DELETE
  ON l11320000
  FOR EACH ROW
  EXECUTE PROCEDURE check_add_reclayer();

CREATE OR REPLACE FUNCTION check_add_reclayer()
  RETURNS trigger AS
$BODY$
          BEGIN
                      IF (TG_OP = 'DELETE') THEN
               IF (current_user != OLD.login AND current_user != 'postgres' AND current_user != 'gis_admin') THEN
                     RETURN NULL;
                ELSE
                     RETURN OLD;
                END IF;
               ELSEIF (TG_OP = 'UPDATE') THEN
                 IF (current_user != OLD.login AND current_user != 'postgres' AND current_user != 'gis_admin') THEN
                     RETURN NULL;
                 ELSE --ELSEIF (current_user = 'postgres' OR current_user = 'gis_admin') THEN
                     NEW.login := current_user;
                  NEW.p9000 := current_user;
                         RETURN NEW;
                 END IF;
               ELSEIF (TG_OP = 'INSERT') THEN
                NEW.login := current_user;
         NEW.p9000 := current_user;
                RETURN NEW;
               END IF;
               RETURN NULL;
         END;
      $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION check_add_reclayer() OWNER TO postgres;

CREATE OR REPLACE FUNCTION l11320000_insert_func()
  RETURNS trigger AS
$BODY$
DECLARE
BEGIN
INSERT INTO _operations(ln, objid, op, uid)
VALUES(
11320000,
new.objectid,
'I'::bpchar,
pg_backend_pid());
RETURN NEW;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION l11320000_insert_func() OWNER TO postgres;