=?UTF-8?Q?Ond=c5=99ej_Bouda?= <obo...@email.cz> writes:
> 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.
Hm, what are the data types of those columns?
And I assume you've got btree_gist installed?
regards, tom lane
