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

=?UTF-8?Q?Ond=c5=99ej_Bouda?= <obouda@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