<div dir="ltr"><div>Hi all,</div><div><br></div><div>Currently, I am working on the pre-sort function for GiST to improve the performance of building index. </div><div>However, when I use `gist_page_items` to debug, with:</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">SELECT * FROM gist_page_items(get_raw_page('tbl_geomcollection_g_idx', 1), 'tbl_geomcollection_g_idx')</blockquote><div>I got:</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span style="font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.95px;white-space:pre-wrap">ERROR: Unknown geometry type: 658326670 - Invalid type
SQL state: XX000</span></blockquote><div><br></div><div><b>tbl_geomcollection</b>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">CREATE TABLE tbl_geomcollection (<br> k serial,<br> g geometry<br>);<br><br>\COPY tbl_geomcollection FROM 'regress_gist_point_.data'<br></blockquote><div><br></div><div> Is it OK to use `gist_page_items` with PostGIS in that way?</div><div>If you have any questions or suggestions, feel free to let me know!</div><div><br></div><div>Best regards,</div><div>Han</div></div>