jsonb column cannot get default value

[devvit]

pg table like this, photos columns with default value

code

DB = Sequel.connect(adapter: 'postgres', database: 'town_dev')
DB.extension :pg_json

Sequel::Model.plugin :defaults_setter

class Post < Sequel::Model

end

output

column score(int type) work well, except photos column

[jeremyevans]

Parsing arbitrary default values is not something that Sequel can do, because it requires a full SQL parser specific to the database, and Sequel does not parse SQL. It's possible that this particular case could be handled, but it invites the slippery slope, since everyone will want custom parsers for their specific case. That's not a path I want to go down.

The default_values plugin already has support for setting the default value manually for specific columns, you should use that:

Post.default_values[:photos] = lambda{Sequel.pg_jsonb('hello'=>'world')}