New answers tagged postgis
You seem to expect that rows with NULL values are excluded from a B-tree index automatically, but that's not the case. Those are indexed as well and can be searched for. However, since: access_type ... is null in 90% of cases that's hardly useful in your case. Such common values hardly ever make sense in an index to begin with, be it NULL or any other ...
Adam, First that is old document -- new one is here: http://postgis.net/docs/AddGeometryColumn.html Though what they say in both is the same. The using that function is only need for 1.5 and below. 2.0 we encourage you to just create the table normally. something like CREATE TABLE test(gid serial primary key, geom geometry(POLYGON, 4326) ); pg_dump ...
It was all caused by the bug described and fixed in this release: http://www.postgresql.org/about/news/1506/ It caused us a lot of trouble!
Top 50 recent answers are included