I am a user of LocalGIS, a Spanish GIS that works with a PostGIS database.
My objective is to edit the layers stored in PostGIS directly using the AutoCAD Map. The problem is that after adding a new feature (POINT) in AutoCAD, I try to open the layer in my GIS and I get an error. I think that something is missing in the way I am doing this cause the GEOMETRY column in the PostGIS table is filled with a WKB format string and the one created in AutocadMAP is so different from the ones previously stored in the database.
I explain the steps I am following just in case something is missing or wrong.
4. After clicking on the "check-in" button to store the changes in the PostGIS database, the GEOMETRY stored for the new registry is quite different from the previous points. In fact, the digits from 3rd to 10th (8 digits) stand for the GEOMETRY type of the feature stored (point,linestring,polygon,multipolygon, geometry collection...) and 00000002 (POINT) is stored for all the features previously in the database and in this case it is stored as 00000008, which I don’t exactly know what it is. https://www.dropbox.com/s/w4lof8l5mv7tq6n/4.%20wkb%20tabla%20POSTGIS%20despues.bmp
The thing is that when creating a new feature from Autocad MAP the EWKB generated in the GEOMETRY column of the postgis table has the SRID=-1 where all the other objects had SRID=23030. When reading the data from my GIS in the select query i called ST_GeomFromWKB("table"."GEOMETRY", 23030) function and everything worked!