When I run the script in the contrib directory against my database, I am able to get my sample of data with JSON columns. However, after I get my data sample, I see the following in my logs:
CONTEXT: SQL function "jsoncmp" during startup
automatic analyze of table "database.public.table"
ERROR: operator does not exist: json = json at character 35
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
QUERY:
select case
when $1 = $2 then 0
when $1 < $2 then -1
else 1
end
I am running Postgres 12.10 in an Ubuntu docker container on a Macbook Pro M1.
How can I fix this?