Mastodon Mastodon - Development
 logo
  • Home 
  • Tags 
  • Blog posts 
  1. Home
  2. Categories
  3. Development

Development

October 20, 2025 •2 min read • Python

Postgres column type inference madness

Very hard-to-debug phenomenon when Postgres does not actually use a defined column type to INSERT values, but tries to infer them based on given values. The Penguin was “surprised”.

In case you want to follow me

Here are some links. The further to the right, the less active.

           
(c) Axel Bock | Powered by Hinode.
Code copied to clipboard