Re: backend crash on DELETE, reproducible locally - Mailing list pgsql-general

Dne 6.11.2018 v 20:45 Alvaro Herrera napsal(a):
> What indexes are there in this table?  Indexes on expressions are
> particularly suspect.

There are some simple btree indexes due to foreign keys, and this one, 
which seems as the cause for the crashes:

CREATE INDEX schedulecard_overlap_idx
     ON public.schedulecard USING gist
     (scheduletemplate_id, (period_day::integer % 7), timerange)
     TABLESPACE pg_default;

When I drop it, the UPDATE statement gets executed without any problems.
When I create the index again, the same UPDATE crashes the server.


Regards,
Ondřej Bouda