Re: v12.0 ERROR: trying to store a heap tuple into wrong type of slot
Justin Pryzby <pryzby@telsasoft.com>
From: Justin Pryzby <pryzby@telsasoft.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2019-10-15T22:26:59Z
Lists: pgsql-hackers
On Tue, Oct 15, 2019 at 01:50:09PM -0700, Andres Freund wrote: > On 2019-10-13 07:51:06 -0700, Andres Freund wrote: > > On 2019-10-11 16:03:20 -0500, Justin Pryzby wrote: > > > ts=# CLUSTER huawei_m2000_config_enodebcell_enodeb USING huawei_m2000_config_enodebcell_enodeb_coalesce_idx ; > > The cause of the error is that, while that sounds like it should be the > > case, a virtual slot isn't sufficient for tuplesort_begin_cluster(). So > > the fix is pretty trivial. Will fix. > > I pushed the fix, including a few tests, a few hours ago. I hope that > fixes the issue for you? On another server already running REL_12_STABLE, I created index with same definition, which didn't previously exist. I failed before pulling and works after. ts=# CLUSTER huawei_m2000_config_enodebcell_enodeb USING huawei_m2000_config_enodebcell_enodeb_coalesce_idx ; CLUSTER Thanks, Justin
Commits
-
Fix CLUSTER on expression indexes.
- 6d3fe6b6bf05 12.1 landed
- cef82eda1464 13.0 landed