Thank you,
it was great help.
particularly your section worked well and helpful ( since I am going to
create geojson outcome from this sql for web app):
---
And I would think you would want one record per road so the union should be
done after, so the below would make more sense.
SELECT road.
Hi,
We have just found a bug involving the recently added BRIN support for
PostGIS datatype.
When new entries are added in an already indexed field, the stored bounding
box is updated
if necessary, but the change is not then logged into the WALs: the
resulting in memory updated
index continue to
I am in the midst of a similar migration right now, though I am going from
9.3 to 9.5, and my OS is CentOS 6. I too have had some troubles, and could
not find a reference that actually worked for me on CentOS, although I had
succeeded with a nearly identical migration on Ubuntu! In the end, the
s