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

[Andreas Forø Tollefsen]

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?
I could not continue my backup process before these tables were dropped.

Thank you for your help Sandro.

Andreas

2011/8/17 Sandro Santilli <strk at keybit.net>

> On Wed, Aug 17, 2011 at 04:03:43PM +0200, Andreas Forø Tollefsen wrote:
> > 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"
>
> Don't worry about those, must be new functions defined in newer postgis
> that weren't available in older one.
>
> > By the way. Can i actually have two databases built from two different
> SVN
> > revisions at the same time? Is that possible at all?
>
> Not easily.
> You'd have to install libraries in two different directories and reference
> the correct one from each postgis.sql file.
>
> --strk;
>
>  ()   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/20110818/1da47c8b/attachment.html>