Skip to content

Common Issues

André Diego Piske edited this page Mar 10, 2025 · 3 revisions

Always use JSONB instead of JSON

If you ever get a "postgres could not identify an equality operator for type json" that means you have tables with JSON columns (not JSONB). IronTrail does not and will not support that data type because it can't be compared in Postgres. Use JSONB instead or TEXT in case you have to store the JSON structure unaltered.

See this stackoverflow answer https://stackoverflow.com/a/24296054 that does a better job at explaining that there is no equality operator for the jsonb data type in Postgres.

Clone this wiki locally