<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Found another one, lurking in the depths of EMPTY</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="margin: 0px;"> select st_astext('MULTILINESTRING(EMPTY,EMPTY)'::geometry::bytea::geometry);</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">returns </div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;"> MULTILINESTRING EMPTY</div><br><div class="bloop_sign" id="bloop_sign_1435171386996397056"><div>Basically our WKB emitter short-circuits on anything that answers true to lwgeom_is_empty() and emits a simple empty of the parent type. So it’s not possible to dump/restore a table that contains a collection empty.</div><div><br></div><div>In related news, gserialized_is_empty doesn’t currently handle collections of empty, it’ll return true for those, unlike lwgeom_is_empty. This is causing some inconsistent results…</div><div><br></div><div>ATB,</div><div><br></div><div>P</div><div><br></div><div><br></div><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br><span>http://postgis.net</span><div><span>http://cleverelephant.ca</span></div><div><br></div></div></body></html>