PostGIS table: sdelayer -o register

Question

Hi,

A bit of background information. I have PostGresql 8.4.1, PostGIS 1.4.0, and I am storing my data with the PostGIS Geometry type. For the most part everything is working nicely, i'm just having a little trouble registering a PostGIS table to my geodatabase. Also I have a schema "gisprod" and a user who is the owner of that schema also named "gisprod".

I keep receiving an error saying "DBMS table not found (-37)" then on the next line "Unable to create registration for table land_Parcels"

My sdelayer command is specified below, I was thinking that it must be the name of my table I have tried the format databaseName.schemaName.tableName and schemaName.tableName all with no luck.sdelayer -o register -l land_Parcels,the_geom -e a -C gid,USER -t PG_GEOMETRY -i sde:postgresql:localhost -D spatial -u gisprod -p mypassword

Thanks in advance
Clueless83

VinceAngelo · Answer

No, 'sdelayer -o register' *is* the way you register a table with geometry with ArcSDE.
 
You'll probably need to contact Tech Support to work this out.
 
- V

DrewBlack · Answer

Hi Vince,

Thanks for the heads up on the coordinate sys.

I get the exact same error of DBMS table not found (-37), and on a new line "'Error: Describing Table."

I have made sure the account SDE has usage on this schema, I am performing the command as the schema and table owner, and the direct connect works fine when performing other commands.

I was just about to click "submit reply" when I decided to create a test table in ArcCatalog and perform a table describe. Reassurance that the table Naming convention, and all the details I am using for the command is correct because it all works fine.

So, I take it I have missed an important step! I have seen documentation referring to registering a table with the gdb then ArcSDE or vice versa. I take it I haven't registered the table with sde? That would explain why it can't find the table?? I obviously missed a step, i'll revisit the documentation!

Thanks
Clueless83

VinceAngelo · Answer

What does 'sdetable -o describe -t land_Parcels -i sde:postgresql:localhost -D spatial 
-u gisprod -p ...' report?
 
What happens if you name the table 'land_parcels2'?
 
Once you get over this issue, you'll need to specify a proper coordinate reference system
with -P and -x parameters (or a -R for a previously defined layer).
 
-V