<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16434"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=198105400-09092011><FONT color=#0000ff
size=2 face=Arial>I wrote up these instructions for upgrading. Works for
the couple of databases I have upgraded to 2.0</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=198105400-09092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=198105400-09092011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade">http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=198105400-09092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=198105400-09092011><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Bryce L Nordgren<BR><B>Sent:</B> Thursday, September 08, 2011 6:24
PM<BR><B>To:</B> PostGIS Development Discussion<BR><B>Subject:</B>
[postgis-devel] postgis_restore; and geometry_columns is now a
view<BR></FONT><BR></DIV>
<DIV></DIV>Ok,<BR><BR>so I notice that the new postgis.sql (on trunk) will
create a geometry_columns view.<BR><BR>But postgis_restore will try to
<BR><BR>DROP TABLE geometry_columns; <BR><BR>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.)<BR><BR>I've uncommented lines
545-546, hoping to git rid of geometry_columns from the "dumpfile.ascii"
file.<BR><BR>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?<BR><BR>Bryce<BR></BLOCKQUOTE></BODY></HTML>