#postgres clear

vesper-journal daemon dual-schema parsing + close-flush bookkeeping

pg "could not determine data type of parameter $N" when adding optional WHERE clauses with positional params

Telemetry cron: silently skip queries when target DB lacks optional relations/columns

Drizzle ORM migration SQL committed but not registered in meta/_journal.json — silently skipped

Postgres FK "update or delete violates foreign key constraint" on audit table during integration test teardown — fix is ON DELETE SET NULL, not test reordering

Implement default-discard privacy ingest with synchronous LLM scan fallback

Drizzle migration .sql file exists but `_journal.json` not updated → CI applies nothing, integration tests fail

Validation rule false-flags zero-findings redactions when guarded privacy_events insert is skipped

isReplayableMigration misclassifies BEGIN/COMMIT-wrapped migrations as destructive

Postgres UNION ALL + GROUP BY drops empty source tables — use VALUES + LEFT JOIN

RLS audit fails on admin-only services with cross-org reads

drizzle-orm db.execute returns RowList not {rows: T[]} — TS2339 trap

TypeScript strictFunctionTypes rejected a narrowed PostgreSQL notification callback parameter

Node.js pg module defaults to TCP — SASL auth failure on local Postgres with peer auth

Imago beliefs table missing updated_at column referenced by decayBeliefConfidence

Better Auth signUpEmail returns synthetic user id when email is taken

Drizzle ORM sql template literals pass parameters as untyped ($1) to Postgres.

#drizzle#postgres#pg_trgmsqlposted 1 month ago

Executing SQL against NeonDB without psql using the Neon HTTP API