| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Subject: | Crash in BRIN minmax-multi indexes |
| Date: | 2021-03-31 17:29:33 |
| Message-ID: | CAJKUy5jLZFLCxyxfT=MfK5mtPfSzHA1rVLowR-j4RRsFVvKm7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| minmax_multi_crash.txt | text/plain | 13.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dilger | 2021-03-31 17:31:50 | Re: pg_amcheck contrib application |
| Previous Message | Tom Lane | 2021-03-31 17:24:01 | Re: making update/delete of inheritance trees scale better |