[postgis-users] ERROR: relation "geometry_columns" does not exist

[Sam Boggess]

I've been using shp2pgsql successfully on a freebsd platform for awhile now. 
I'd then take the the .sql file I out put and run it as a batch file on PG
Navicat.  I was doing a bunch of these and all of a sudden I started getting
this error:

Error at query 3: ERROR:  relation "geometry_columns" does not exist
CONTEXT:  SQL statement "DELETE FROM geometry_columns WHERE
		f_table_catalog = '' AND f_table_schema = 'public' AND f_table_name =
'cottonwood_wa' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 102 at execute statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement


I've gone back and tried to redo some that worked previously and they get
this error now too.  I tried restarting PG, but no luck.  Any help would be
greatly appreciated.  This is very frustrating!
-- 
View this message in context: http://www.nabble.com/ERROR%3A--relation-%22geometry_columns%22-does-not-exist-tp15867873p15867873.html
Sent from the PostGIS - User mailing list archive at Nabble.com.