why is a non null postgres column with default throwing a constraint error

Welcome to Mixible, your go-to source for comprehensive and informative content covering a broad range of topics from Stack Exchange websites. Our channel is committed to providing you with valuable insights and discussions on various subjects, ensuring that you stay informed about the latest trends and developments in your area of interest.

We offer an extensive library of videos that cover a wide range of topics, including programming, computer science, mathematics, physics, and much more. Our videos are designed to cater to diverse audiences, ranging from beginners to advanced learners, and are presented in an engaging and easy-to-understand format.

At Mixible, we are dedicated to being a trusted source of information. We base our videos on questions and answers posted on various Stack Exchange sites, including:

Stack Overflow for programming-related questions
Super User for computer software and hardware-related questions
Mathematics for mathematical questions
Physics for physics-related questions
Cross Validated for statistics and data analysis-related questions
Server Fault for server and network-related questions
and many more!
We give credit to the specific threads that inspire our content at the end of each video. Additionally, you can visit the Stack Exchange website (https://stackexchange.com/) for more information on the topics we cover.

So, if you're looking to expand your knowledge and stay up-to-date with the latest trends and developments, subscribe to Mixible today, and join our community of curious minds.

Thank you for watching!

Link to Stack Overflow: https://stackoverflow.com/