[postgis-devel] postgis_restore; and geometry_columns is now a view

Bryce L Nordgren bnordgren at gmail.com
Thu Sep 8 15:23:45 PDT 2011


Ok,

so I notice that the new postgis.sql (on trunk) will create a
geometry_columns view.

But postgis_restore will try to

DROP TABLE geometry_columns;

Won't work because it's a view now. Also, the script is setup to replace the
geometry_columns from postgis.sql with the geometry_columns from the
dumpfile. Meaning the "dumpfile.ascii" tries to create a geometry_columns
table (won't work because a view with the same name already exists.)

I've uncommented lines 545-546, hoping to git rid of geometry_columns from
the "dumpfile.ascii" file.

Is this a real problem or am I just making things difficult where they
shouldn't be? Does postgis_restore need to get smarter before the release?

Bryce
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20110908/48c79362/attachment.html>


More information about the postgis-devel mailing list