IPV4 column type possible bug?

[bougyman]

When I save any record in this profile table, I get the following error:

[19] pry(main)> prof.reload.save
2025-02-12 16:28:45.857305 I [40513:3800] DB -- (0.002467s) SELECT * FROM "profiles" WHERE "id" = 'b58cfda7-2c15-4165-82ab-4952a890aeef'
2025-02-12 16:28:45.858384 I [40513:3800] DB -- (0.000665s) BEGIN
Sequel::Error: can't express #<IPAddr: IPv4:172.71.31.76/255.255.255.255> as a SQL literal
from /usr/local/bundle/gems/sequel-5.89.0/lib/sequel/dataset/sql.rb:1442:in `literal_other_append'
2025-02-12 16:28:45.859681 I [40513:3800] DB -- (0.000663s) ROLLBACK

Table schema as follows:

# Table: profiles
# Columns:
#  id                                    | uuid                     | PRIMARY KEY
#  provider_uuid                          | uuid                     |
#  status                                | text                     | NOT NULL DEFAULT 'INACTIVE'::text
#  locale                                | text                     |
#  first_name                            | text                     | NOT NULL
#  last_name                             | text                     | NOT NULL
#  middle_name                           | text                     |
#  date_of_birth                         | date                     | NOT NULL
#  email                                 | text                     |
#  phone                                 | text                     |
#  ip                                    | inet                     |
#  nationality                           | text                     |
#  gender                                | text                     |
#  cell_phone                            | text                     |
#  payment_token                         | text                     |
#  created                               | timestamp with time zone |
#  updated                               | timestamp with time zone |
#  override_withdrawal_daily_restriction | boolean                  | DEFAULT false
# Indexes:
#  profiles_pkey               | PRIMARY KEY btree (id)
#  profiles_provider_uuid_key   | UNIQUE btree (provider_uuid)
#  profiles_provider_uuid_index | btree (provider_uuid)
#  profiles_status_index       | btree (status)
# Triggers:
#  pgt_ca_created                | BEFORE INSERT OR UPDATE ON profiles FOR EACH ROW EXECUTE FUNCTION profiles_pgt_created()
#  pgt_profiles_immutable_fields | BEFORE UPDATE ON profiles FOR EACH ROW EXECUTE FUNCTION pgt_profiles_immutable_fields()
#  pgt_ua_updated                | BEFORE INSERT OR UPDATE ON profiles FOR EACH ROW EXECUTE FUNCTION profiles_pgt_updated()

Anything needed to support that ipv4 field?

[jeremyevans]

You probably want to use the pg_inet extension, which will handle literalization of the IPAddr type. The issue here is that sequel_pg converts the column values to IPAddrwhen retrieving the value from the database (which pg_inet also does), but sequel_pg doesn't handle the literalization of IPAddr instances. Admittedly, this is suboptimal, but it operates this was so that sequel_pg can speed up conversion of inet/cidr columns.

[bougyman]

Thanks! Will add that extension.