Unable to insert null into a not null default current_timestamp record of postgresql enterprise

sam · February 27, 2025, 12:20am

I am confused, we set the sedfault here:

db/migrate/20190402024053_add_first_unread_at_to_user_stats.rb

fbe5a9c71


      
          if !column_exists?(:user_stats, :first_unread_at)
            add_column :user_stats,
                       :first_unread_at,
                       :datetime,
                       null: false,
                       default: -> { "CURRENT_TIMESTAMP" }
          end

Topic		Replies	Views
PG::NotNullViolation: ERROR: null value in column "verification_status" violates not-null constraint Bug	6	3007	September 17, 2020
Upgrade failed: null value in column "updated_at" violates not-null constraint Product Support	4	2747	August 9, 2017
Vbulletin bulk importer: null value in column "pinned_globally" of relation "topics" violates not-null constraint Development	6	176	May 15, 2025
Vanilla Migration Issue Development	7	1121	February 21, 2017
PG13 compatibility issue :fire: Bug	8	623	October 23, 2024

Unable to insert null into a not null default current_timestamp record of postgresql enterprise

Related topics