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

ERROR: relation "geometry_columns" does not exist

by Sam Boggess :: Rate this Message:

Reply to Author | View in Thread

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!

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

LightInTheBox - Buy quality products at wholesale price!