Chris van Eijk: invalid input syntax for type json in PostgreSQL, measured

Planet PostgreSQL2026-11-16 06:300 views

What raises 'invalid input syntax for type json' (22P02), measured on PostgreSQL 16 to 18: JS arrays, Python lists, NUL escapes, bad rows and a safe ALTER.

Source：https://postgr.es/p/9C2

My favorites

PreviousLinux 7.4-rc3 Released: "The Usual Noise All Over"NextA datetime library for Rust

Show HN: Straum – PostgreSQL Group by in Microseconds

I've seen too many slow-log queries with a GROUP BY that makes Postgres blow up, so for the last two weeks or so I've be

0Hacker News Show

Show HN: Rbit – Self Hosted Git Forge in Rust

rbit is a self hosted git forge designed around three core philosophies: speed, security, and efficiency. We built rbit

0Hacker News Show

Please Implement A Quorum Database

Comments

0Lobsters

Compiling n8n Workflow JSONs into Standalone Fastify/TypeScript Microservices (Open-Source + Client-Side Playground)

n8n is fantastic for prototyping and visual orchestration. You can wire up webhooks, databases, and LLM calls in minutes

0dev.to

My N+1 test plugin failed 551 tests on someone else's project. Nearly all of them were noise.

I maintain pytest-queryguard, a pytest plugin that fails a test when the code it runs sends one query per row. The probl

0dev.to

Why LLMs Quietly Round Up Your Resume Metrics (And How I Blocked It Without Another LLM)

If you ask an AI to "tailor my resume to this job description without making anything up," it still tries to help you a

0dev.to TypeScript