Great. Thank you Sandro. That worked. I managed to install the 6874 SVN and are now able to query the geometry columns as well.
I then tried to backup the database, but got an error on two of my tables regarding the function postgis_typmod_out. Both of the tables in question have been read from a CSV file into a table in the database. I dropped these tables and now i can backup the database. The complete error: "ERROR: could not find the function "postgis_typmod_out" in file "/usr/lib/postgresql/8.4/lib/postgis-2.0.so" By the way. Can i actually have two databases built from two different SVN revisions at the same time? Is that possible at all? Andreas 2011/8/17 Sandro Santilli <s...@keybit.net> > On Wed, Aug 17, 2011 at 03:29:34PM +0200, Andreas Forø Tollefsen wrote: > > I see. However I cannot dump my db anymore either. > > When for instance: pg_dump -Fc db1 > db1.dump > > I get the same ERROR: Unknown geometry type: -256 - Unknown. > > Did you do: > > > > Check SVN history and get back in time. > > ? > > --strk; > > > > > > > 2011/8/17 Sandro Santilli <s...@keybit.net> > > > > > Starting from a specific revision, a new serialized format was > > > enabled, requiring you to do a dump/reload. > > > Check SVN history and get back in time. > > > If you want to jump over, dump, svn up and restore. > > > > > > --strk; > > > > > > On Wed, Aug 17, 2011 at 03:14:23PM +0200, Andreas Forø Tollefsen wrote: > > > > Hi all. > > > > > > > > I was experimenting with some raster functionality in the SVN 6874. > > > However, > > > > as there were some fixed bugs in later version I decided to create a > new > > > > database on my server using SVN 7749. > > > > When installing this i must have updated some of the libraries, GEOS > i > > > guess > > > > and maybe others. > > > > > > > > The problem now is that while the 7749 database works flawless, the > 6874 > > > > have become corrupted. > > > > When querying any geometry column i get this: > > > > SELECT cshapes.geom FROM cshapes; > > > > results in: > > > > ERROR: Unknown geometry type: 0 - Unknown > > > > > > > > It does not matter whether i query from remote or from the actual > server. > > > > > > > > Any ideas on whether it is possible to solve this issue? > > > > I will eventually recreate all of my data on the 7749 database, but > as > > > for > > > > now i need to access the geometries stored in the 6874 database. > > > > > > > > Thank you in advance. > > > > > > > > Andreas > > > > > > > _______________________________________________ > > > > postgis-users mailing list > > > > postgis-users@postgis.refractions.net > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > > > -- > > > > > > () Free GIS & Flash consultant/developer > > > /\ http://strk.keybit.net/services.html > > > _______________________________________________ > > > postgis-users mailing list > > > postgis-users@postgis.refractions.net > > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > -- > > () Free GIS & Flash consultant/developer > /\ http://strk.keybit.net/services.html > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
