Thread: PG-Sample | Error | Equality operator for type json
Hi Team, I’m getting running into following issue while executing pg-sample Error ==== DBD::Pg::db do failed: ERROR: could not identify an equality operator for type json LINE 3: SELECT DISTINCT t1.* ^ at ./pg_sample line 296. main::__ANON__("DBD::Pg::db do failed: ERROR: could not identify an equality"..., DBI::db=HASH(0x1704258), undef) calledat ./pg_sample line 638 /pg_sample$ ./pg_sample mydb | psql sampledb ==== Executing Command ==== pg_sample mydb | psql sampledb ==== — Thanks Abhinav
BTW - I’ve tried figuring out myself and understood UNION workaround could help, but since it’s via pg-sample so just want to understand if there a quick workaround without tweaking pg-sample itself.
On 24-Aug-2018, at 6:20 PM, Abhinav Mehta <abhinav@metarain.com> wrote:Hi Team,
I’m getting running into following issue while executing pg-sample
Error
====
DBD::Pg::db do failed: ERROR: could not identify an equality operator for type json
LINE 3: SELECT DISTINCT t1.*
^ at ./pg_sample line 296.
main::__ANON__("DBD::Pg::db do failed: ERROR: could not identify an equality"..., DBI::db=HASH(0x1704258), undef) called at ./pg_sample line 638
/pg_sample$ ./pg_sample mydb | psql sampledb
====
Executing Command
====
pg_sample mydb | psql sampledb
====
—
Thanks
Abhinav