09 – PostgreSQL Triggers and Functions

Theory

Trigger function anatomy

Use cases

Cross-cutting considerations

Task

Full Working Code

SQL Setup (`@BeforeEach`)

`src/test/java/com/example/demo/repository/TriggerTest.java`

Expected Output

Order number format:

Audit entries after status transitions:

Triggers on orders:

Verification Steps