If you really want to run an agent on each created row, you could run this in a replica and stream the replies back to your system of record.
replyTo decouple this the person would have to broadcast nearly every event and rebuild the observer layers elsewhere.
replyYou could replicate and separate your llm-postgres from the system-of-record-postgres.
replyAnd IMO that's what should be done.
replyDon't get me wrong, I like the idea and all that, but this is another pgsql "solution" that is tied to the database layer, when it should be in the application layer.
I like to be database agnostic, and while I prefer PostgreSQL on production, I prefer SQLite on the dev layer. You should never have to HAVE TO use a specific database to make your APPLICATION work.