I was trying to import shp to postgis database and i get the following error:
Importing with configuration: adresy92, public, geom, C:\Users\tomek\Desktop\adresy92, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=0 Shapefile type: PointZ PostGIS type: POINT Failed SQL begins: "SET CLIENT_ENCODING TO UTF8; SET STANDARD_CONFORMING_STRINGS TO ON; BEGIN; CREATE TABLE "public"."adresy92" (gid serial, "obrot" int2, "dane_kod" int2, "xy_dane" varchar(20), "status_kod" int2, "xy_status" varchar(50), "ulica_kod" int2, "miejsc_kod" int2" Failed in pgui_exec(): ERROR: AddGeometryColumns() - invalid SRID CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )" PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement Shapefile import failed.
The stange thing is that I have already put a couple shapefiles to this database without any problems.
I am importing shapefile through SPIT tool from Quantum GIS 1.8.0.
I have also tried to do the same via shp2pgsql plugin in pgAdmin with the same result.
PS I found a similar question on gis.stackexchange but it didn't solve my problem.
I would be appreciate for your help.