Chris van Eijk: invalid input syntax for type json in PostgreSQL, measured
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.
Daily edition · Databases
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
3 articles · 3 sources ·
Top topics: PostgreSQL · AI · General
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.
Datasentinel 2026.10, the new release of our PostgreSQL monitoring and troubleshooting platform, is now available. It introduces AI Connector, which connects Datasentinel metrics to the AI assistant your team already…