Crash in BRIN minmax-multi indexes - Mailing list pgsql-hackers

From Jaime Casanova
Subject Crash in BRIN minmax-multi indexes
Date
Msg-id CAJKUy5jLZFLCxyxfT=MfK5mtPfSzHA1rVLowR-j4RRsFVvKm7A@mail.gmail.com
Whole thread Raw
Responses Re: Crash in BRIN minmax-multi indexes  (Zhihong Yu <zyu@yugabyte.com>)
List pgsql-hackers
Hi,

Just found $SUBJECT involving time with time zone and a subselect. I
still don't have narrowed to the exact table/index minimal schema but
if you run this query on the regression database it will creash.

```
update public.brintest_multi set
  timetzcol = (select tz from generate_series('2021-01-01'::timestamp
with time zone, '2021-01-31', '5 days') tz limit 1)
;
```

attached a backtrace. Let me know if you need extra information.

--
Jaime Casanova
Director de Servicios Profesionales
SYSTEMGUARDS - Consultores de PostgreSQL

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: making update/delete of inheritance trees scale better
Next
From: Mark Dilger
Date:
Subject: Re: pg_amcheck contrib application