« Return to Thread: ERROR: relation "geometry_columns" does not exist

Re: ERROR: relation "geometry_columns" does not exist

by Sam Boggess :: Rate this Message:

Reply to Author | View in Thread


Mark Cave-Ayland-3 wrote:
Hi Sam,

Unfortunately you haven't told us how you generated your .sql files, what was
in them, how you are trying to restore them and what version of PostgreSQL
you are using. So without more information we can't help you much :(

On the positive side, the ERROR above is fairly obvious - you are missing the
PostGIS geometry_columns table either from your database or earlier on in
your .sql file.


HTH,

Mark.

--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Mark,

Thank you for the reply.  It looks like my issue as simple as I must have accidentally deleted the geometry_columns table when I was cleaning up my database.  What would be the easiest way to restore it?

Thank you for your assistance,
Sam


 « Return to Thread: ERROR: relation "geometry_columns" does not exist