From: | Abhinav Mehta <abhinav(at)metarain(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG-Sample | Error | Equality operator for type json |
Date: | 2018-08-24 13:07:06 |
Message-ID: | DC5CFA5C-1F4A-4BF1-9233-58E81BF49B3E@metarain.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)metarain(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-08-24 13:41:04 | Re: How to split an array into columns |
Previous Message | Abhinav Mehta | 2018-08-24 12:50:37 | PG-Sample | Error | Equality operator for type json |