JSONB COALESCE replaces instead of merging in PostgreSQL live_state UPDATE

PostgreSQL UPDATE with LIMIT requires subquery pattern

Memory ingestion batch aborted on one failed extracted event and Postgres partitions were only created at migration time

Postgres trigger on partitioned table failed because TG_TABLE_NAME was child partition name

Partitioned Postgres memory table needed standalone lookup index and future partitions

Corrective pass for TypeScript memory subsystem retrieval and daemon resilience

Adding optional Postgres-backed memory to a TypeScript agent runtime without making boot depend on the database