virtual column for PG

test.rb

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  gem "rails"
  gem "pg"
end

require "active_record/railtie"
require "minitest/autorun"

ENV["DATABASE_URL"] = "postgres://postgres:mysecretpassword@localhost:5432/postgres"

class TestApp < Rails::Application
  config.load_defaults Rails::VERSION::STRING.to_f
  config.eager_load = false
  config.logger = Logger.new($stdout)
  config.secret_key_base = "secret_key_base"
end
Rails.application.initialize!

ActiveRecord::Schema.define do
  create_table :users, force: true do |t|
    t.string :name, null: false
    t.virtual :upcase_name, type: :string, as: "UPPER(name)"
  end
end

class User < ActiveRecord::Base
end

class BugTest < ActiveSupport::TestCase
  def test_migration_up
    User.reset_column_information

    User.create!(name: "John Doe")
    user = User.first

    assert_equal "JOHN DOE", user.upcase_name
  end
end

/home/mtsmfm/.local/share/mise/installs/ruby/3.4.3/lib/ruby/gems/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/postgresql/schema_creation.rb:134:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaCreation#add_column_options!': PostgreSQL currently does not support VIRTUAL (not persisted) generated columns. (ArgumentError)
Specify 'stored: true' option for 'upcase_name'