Обсуждение: PG-Sample | Error | Equality operator for type json

Поиск
Список
Период
Сортировка

PG-Sample | Error | Equality operator for type json

От
Abhinav Mehta
Дата:
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

Re: PG-Sample | Error | Equality operator for type json

От
Abhinav Mehta
Дата:
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