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) called at ./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.
Show quoted text
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