[postgis-users] ERROR: Unknown geometry type: 0 - Unknown

[Andreas Forø Tollefsen]

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 <strk at 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 <strk at 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 at 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 at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
>
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110817/50e51849/attachment.html>