Horton

Re: backend crash on DELETE, reproducible locally

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karsten Hilbert <Karsten.Hilbert@gmx.net>, pgsql-general <pgsql-general@postgresql.org>
Cc: pg-users@hermes.hilbert.loc
Date: 2018-11-01T14:35:40Z
Lists: pgsql-hackers, pgsql-general 
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> I am running this delete statement via psql
> 	DELETE FROM ref.auto_hint WHERE title = 'Kontraindikation: ACE/Sartan <-> Schwangerschaft';

Doesn't look particularly special ...

> What else can I provide/test/look into ?

Stack trace would be helpful, self-contained test case even better.

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

			regards, tom lane

Commits

  1. Disable recheck_on_update optimization to avoid crashes.

  2. Allow HOT updates for some expression indexes