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

Поиск
Список
Период
Сортировка
От Abhinav Mehta
Тема Re: PG-Sample | Error | Equality operator for type json
Дата
Msg-id DC5CFA5C-1F4A-4BF1-9233-58E81BF49B3E@metarain.com
обсуждение исходный текст
Ответ на PG-Sample | Error | Equality operator for type json  (Abhinav Mehta <abhinav@metarain.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Abhinav Mehta
Дата:
Сообщение: PG-Sample | Error | Equality operator for type json
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to split an array into columns