Skip to content

ERROR: operator does not exist: json = json at character 35 #48

@jeffsutherland-bluesky

Description

@jeffsutherland-bluesky

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions