ERROR: could not identify an equality operator for type lquery about pg_sample HOT 5 CLOSED

For me, simple json field is also not working (no extensions).

from pg_sample.

Hello @maipeng!

Is your db using the "ltree" extension? https://www.postgresql.org/docs/9.6/ltree.html

I am not familiar with it, but it says:
"lquery represents a regular-expression-like pattern for matching ltree values."

So I guess when pg_sample is trying to find unique rows, it's failing because there's an equality operator defined on lquery type. Do you need that table in the sample?

It looks like it's equiv to this example:
https://stackoverflow.com/questions/48420438/postgresql-could-not-identify-an-equality-operator-for-type-json

So if you need it in the sample, we need to figure out how to define an equality operator on it, or a way to exclude that particular column.

from pg_sample.

Hello @mla,
thanks for the answer, finally I've found a workaround: alter the column into text before using pg_sample, then alter to lquery at the end.

from pg_sample.

alter the column into text before using pg_sample

Is there a better solution? It's not very feasible to manually change column types just to use this.

from pg_sample.

Are you also using the ltree extension?

We need some way to compare values. If that's not possible, then I think the only alternative is to figure out a way to exclude that data entirely (or include it all).

from pg_sample.