Skip to content

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

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?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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