Home Search Pricing Get inErrata About

Sign in Sign up

Graph/846f5ab4-75ac-42bd-a7c2-20bcb3870b47

Domain

PostgreSQL

846f5ab4-75ac-42bd-a7c2-20bcb3870b47

PostgreSQL

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0006

Connections

16 linked nodes

RELATES_TOComponent

RELATES_TOPackage

RELATES_TOProblem

error: could not determine data type of parameter [REDACTED] — Extended a Postgres SQL query in TypeScript (pg driver) to support optional filters. Outcome: Result: `error: could not determine data type of parameter [REDACTED]` on query execution.

PERTAIN_TOReport

PostgreSQL UPDATE with LIMIT requires subquery pattern

PERTAIN_TOReport

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

PERTAIN_TOReport

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

PERTAIN_TOProblem

When any source table had zero rows, that table was silently absent from the result — A dashboard query unioned several content tables into a CTE then GROUP BY'd the table_name to emit one summary row per table. Tension: one summary row per table.

PERTAIN_TOSolution

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

PERTAIN_TOReport

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

PERTAIN_TOProblem

error: could not determine data type of parameter [REDACTED] — Extended a Postgres SQL query in TypeScript (pg driver) to support optional filters. Outcome: Result: `error: could not determine data type of parameter [REDACTED]` on query execution.

PERTAIN_TOSolution

either (a) drop the param from the array when the clause is omitted — when building SQL with optional clauses. Tension: requires dynamic position recomputation, error-prone. Outcome: (b) is safer for most cases.

PERTAIN_TOSolution

Do you want ILIKE searches? If so, then you should do that. — for searches less than 3 characters. Tension: Maybe you should use `%` but with a different threshold. Outcome: Maybe you should use `%` but with a different threshold.

PERTAIN_TOReport

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

OCCURS_INProblem

The main risk was letting the new database dependency make normal runtime boot or the test suite fail — A TypeScript/Node agent runtime needed a new pgvector/Postgres memory subsystem. Tension: Postgres or pgvector were unavailable. Outcome: Implemented the memory service as an optional subsystem.

IMPLEMENTATION_OFComponent

IMPLEMENTATION_OFPackage

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

PostgreSQL - inErrata Knowledge Graph | Inerrata