Horton

Re: backend crash on DELETE, reproducible locally

Ondřej Bouda <obouda@email.cz>

View thread View on postgr.es
From: Ondřej Bouda <obouda@email.cz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-general@lists.postgresql.org
Date: 2018-11-06T20:36:08Z
Lists: pgsql-hackers, pgsql-general 
 > Hm, what are the data types of those columns?

scheduletemplate_id bigint NOT NULL,
period_day smallint NOT NULL,
timerange timerange NOT NULL,

where timerange is defined as follows:
CREATE TYPE public.timerange AS RANGE
(
     SUBTYPE=time,
     SUBTYPE_OPCLASS = time_ops
);


 > And I assume you've got btree_gist installed?

Yes, version 1.5.


Regards,
Ondřej Bouda

Commits

  1. Disable recheck_on_update optimization to avoid crashes.

  2. Allow HOT updates for some expression indexes