How to fix Triggered data change violation in PostgreSQL

SELECT tgname, tgfoid, tgtype FROM pg_trigger WHERE tgname = 'your_trigger_name';

SELECT prosrc FROM pg_proc WHERE oid = (SELECT tgfoid FROM pg_trigger WHERE tgname = 'your_trigger_name');

CREATE OR REPLACE FUNCTION audit_changes()
RETURNS TRIGGER AS $$
BEGIN
  INSERT INTO audit_log (table_name, operation, changed_at)
  VALUES (TG_TABLE_NAME, TG_OP, NOW());
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER prevent_invalid_data
BEFORE UPDATE ON my_table
FOR EACH ROW
EXECUTE FUNCTION validate_and_fix_data();

CREATE OR REPLACE FUNCTION update_modified_date()
RETURNS TRIGGER AS $$
BEGIN
  IF (SELECT COUNT(*) FROM pg_stat_activity WHERE query LIKE '%update_modified_date%') > 1 THEN
    RETURN NEW;  -- Skip if already executing
  END IF;
  NEW.modified_at = NOW();
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

ALTER TABLE my_table DISABLE TRIGGER trigger_name;
-- perform operations --
ALTER TABLE my_table ENABLE TRIGGER trigger_name;

-- BEFORE trigger: can modify NEW or OLD
CREATE TRIGGER normalize_data
BEFORE INSERT OR UPDATE ON my_table
FOR EACH ROW
EXECUTE FUNCTION normalize_columns();

-- AFTER trigger: data already committed, use for side effects
CREATE TRIGGER log_changes
AFTER INSERT OR UPDATE ON my_table
FOR EACH ROW
EXECUTE FUNCTION log_to_audit_table();

-- Test INSERT
INSERT INTO my_table (column1, column2) VALUES ('test', 'data');

-- Test UPDATE
UPDATE my_table SET column1 = 'updated' WHERE id = 1;

-- Test DELETE
DELETE FROM my_table WHERE id = 1;

-- Monitor for errors
SET log_statement = 'all';