Re: out of memory error

2012-05-23 21:15:45 WET LOG:  execute <unnamed>:           CREATE OR REPLACE FUNCTION "rr_ptz_lock"() RETURNS TRIGGER AS $change_trigger$
                BEGIN
                              PERFORM ACTIVE FROM "public".rr_running_flags;
                IF FOUND THEN
                  RETURN NULL;
                END IF;
   
                  IF (TG_OP = 'DELETE') THEN
                    INSERT INTO "public".rr_pending_changes(change_table, change_key, change_type, change_time)
                      SELECT 'ptz_lock', 'workstation_id|' || OLD."workstation_id" || '|' || 'camera_id|' || OLD."camera_id", 'D', now();
                  ELSIF (TG_OP = 'UPDATE') THEN
                   
                    INSERT INTO  "public".rr_pending_changes(change_table, change_key, change_new_key, change_type, change_time)
                      SELECT 'ptz_lock', 'workstation_id|' || OLD."workstation_id" || '|' || 'camera_id|' || OLD."camera_id", 'workstation_id|' || NEW."workstation_id" || '|' || 'camera_id|' || NEW."camera_id", 'U', now();
                  ELSIF (TG_OP = 'INSERT') THEN
                    INSERT INTO  "public".rr_pending_changes(change_table, change_key, change_type, change_time)
                      SELECT 'ptz_lock', 'workstation_id|' || NEW."workstation_id" || '|' || 'camera_id|' || NEW."camera_id", 'I', now();
                  END IF;
                  RETURN NULL; -- result is ignored since this is an AFTER trigger
                END;
              $change_trigger$ LANGUAGE plpgsql