I have ArcSDE installed in a Postgresql database and I am using PostGIS geometry. I'm not a DB minded person so feel free to let me know if my process is not right.
I create my feature class in ArcCatalog (no probs) I then go into PgAdminlll to check out the new table. There are two things I notice when I check out my new table.
1) The record for my new table in the public.geometry_columns table has an SRID of -1. Is there any way to set the SRID during the feature class creation? If not how do I do this in PgAdminlll? Is it something like updateGeometry or addGeometry?
2) Also I notice that in PgAdminlll under the newly created tables properties there is no primary key assigned. So what I have been doing is assign the sde created objectid field as the primary key. Is this acceptable or should I be creating a new PK?
Thanks
Ando
Best Answer
ad 1) If you view the contents of geometry_columns table (in PgAdmin3), you can simply double-click into the srid cell and type in any SRID you want. (If you have write access of course).
ad 2) Assuming that the SDE's objectid is kept unique and doesn't change, it shouldn't be a problem to use it as a primary key. I guess SDE doesn't create the tables with OIDs?