Skip to content

Postgres error on long message #149

Open
@SimonLab

Description

@SimonLab

image

The schema is using the string type value for the message which means for long message the value can't be saved and postgres returns an error:
https://github.com/dwyl/phoenix-liveview-chat-example/blob/f4812190ac7f9620a6244f91c00e1d2425170dae/priv/repo/migrations/20211122121548_create_messages.exs

We can either use a differnt type for the field:
image
https://hexdocs.pm/ecto_sql/Ecto.Migration.html#module-field-types

Or display an error on the client. It is easy to add a new migration to update the field type and I'm tempted to go in that direction

Metadata

Metadata

Assignees

Labels

bugSuspected or confirmed bug (defect) in the code

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions