| seq | sqlstate | query |
|---|---|---|
| 1 | — | select name, price from products |
| 2 | 42703 | select name, prise from products where price > 100 |
| 3 | 42601 | SELCT name, price FROM products WHERE price > 100; |
| 4 | — | select name, price from products where price > 100 |
Line 3 — a typo in a keyword. Such a query fails at parsing and never reaches the executor: for pgAudit and the server log it does not exist at all.
And for a database course this is the most valuable material — you see the exact moment the student was hunting for the error, and how long it took.
Wireward sits in the gap between the student's client and the cluster and sees both sides of the conversation.