On 5/20/19 9:55 AM, Will Hartung wrote:
Please reply to list also.
Ccing list.
On Sat, May 18, 2019 at 6:55 AM Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
In addition to what Tim asked:
Is the jsonb field the only field in the table?
Can we see the table schema?
Did you see Tom Lane's post?
# \d eis_entity
Table "public.eis_entity"
Column | Type | Collation |
Nullable | Default
---------------------------+--------------------------+-----------+----------+---------
eis_entity_key | numeric | | not
null |
eis_identifier_domain_key | numeric | | not
null |
global_id | character varying(80) | | not
null |
local_id | character varying(80) | | not
null |
eis_status_key | numeric | | not
null |
eis_entity_type_key | numeric | | not
null |
eis_entity_domain_key | numeric | | not
null |
all_trait_hash | numeric(10,0) |
| |
searchable_trait_hash | numeric(10,0) |
| |
created_date | timestamp with time zone |
| |
traits | jsonb |
| |
current_revision | numeric(8,0) | | not
null |
current_version_label | character varying(10) | | not
null |
Indexes:
"eis_ent_traits" gin (traits jsonb_path_ops)
--
Adrian Klaver
adrian.kla...@aklaver.com
