<div>But is it correct that to be able to create a backup, tables creating these errors must be dropped from the DB before a proper backup can be done?</div><div>I could not continue my backup process before these tables were dropped.</div>
<div><br></div>Thank you for your help Sandro.<div><br></div><div>Andreas<br><br><div class="gmail_quote">2011/8/17 Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net">strk@keybit.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Wed, Aug 17, 2011 at 04:03:43PM +0200, Andreas Forø Tollefsen wrote:<br>
> Great. Thank you Sandro.<br>
><br>
> That worked. I managed to install the 6874 SVN and are now able to query the<br>
> geometry columns as well.<br>
><br>
> I then tried to backup the database, but got an error on two of my tables<br>
> regarding the function postgis_typmod_out.<br>
> Both of the tables in question have been read from a CSV file into a table<br>
> in the database. I dropped these tables and now i can backup the database.<br>
> The complete error: "ERROR: could not find the function "postgis_typmod_out"<br>
> in file "/usr/lib/postgresql/8.4/lib/<a href="http://postgis-2.0.so" target="_blank">postgis-2.0.so</a>"<br>
<br>
</div>Don't worry about those, must be new functions defined in newer postgis<br>
that weren't available in older one.<br>
<div class="im"><br>
> By the way. Can i actually have two databases built from two different SVN<br>
> revisions at the same time? Is that possible at all?<br>
<br>
</div>Not easily.<br>
You'd have to install libraries in two different directories and reference<br>
the correct one from each postgis.sql file.<br>
<br>
--strk;<br>
<div><div></div><div class="h5"><br>
() Free GIS & Flash consultant/developer<br>
/\ <a href="http://strk.keybit.net/services.html" target="_blank">http://strk.keybit.net/services.html</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div>