SShortSingh.
Back to feed

n8n's Postgres Node Doesn't Send Parameters. My Dry-Run Did.

0
·1 views

The n8n docs for the Postgres node say you can use $1, $2 and $3 in a query "to build prepared statements to use with query parameters." On September 18 I found out what that means in practice, from a failure that my own dry-run had told me couldn't happen. I was running an end-to-end test of a workflow I maintain that books a callback. One Postgres node stores when the callback is due, and the number of minutes comes from earlier in the flow. Sometimes there is no number, so the value is an empty string. Simplified, the node's query looked like this: SELECT CASE WHEN $1 = '' THEN NULL ELSE ma

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Falsify — Find the Smallest Input That Breaks Your C++ Solution (Local AI, No API Keys)

What I Built Every competitive programmer knows the pain of passing all sample cases but getting a "Wrong Answer" on submission. The classic fix is stress testing, which means writing three separate programs every time you're stuck. I built this for a friend (and myself) who spends more time setting up stress tests than actually solving problems. Demo bash ollama pull gemma4:latest git clone https://github.com/Sohith2007/falsify.git http://localhost:8000 to use the tool. Here is a look at the Web UI finding a deliberate integer overflow bug in real-time: [UPLOAD IMAGE 1 HERE: ui_full_page_1791

0
ProgrammingDEV Community ·

Sidekick part 4: safety as honestly labeled ceilings

Sidekick Part 4: safety as a stack of ceilings, each honestly labeled Most agent safety I've seen is a paragraph in the system prompt: "be careful with destructive commands." Small models ignore system prompts — we established that in Part 2. So Sidekick's safety model assumes the model will disobey and enforces the boundaries in code instead. This is Part 4: approvals, hard refusals, egress control, and the audit ledger — plus the ceilings, stated rather than hidden. Reads auto-run. Everything else sits in APPROVAL_TOOLS — writes, deletes, general shell — gated behind inline [y/N] prompts, wi

0
ProgrammingDEV Community ·

I built my friend a Spanish tutor that runs on her laptop and never phones home

This is a submission for the Hacktoberfest Weekend Challenge: Build for a Friend I built a Spanish practice partner for a friend who is learning from scratch and freezes when a real person talks to her. Ordering food is the specific thing: she can read a menu, but when the waiter asks "¿algo más?" she has to stop and translate in her head, and the moment passes. So I made LingoBuddy — a terminal program she talks to instead. It holds a conversation with her in Spanish at her level, translates every line into English so she can check her own meaning, and corrects her when she drops an accent. I

n8n's Postgres Node Doesn't Send Parameters. My Dry-Run Did. · ShortSingh