Hi All,
I am using PostGRES 8.3 in conjunction with ESRI’s ArcSDE. ArcSDE allows the storage of spatial data inside of an PostGRES database. One of the programs bundled with ESRI’s GIS suite is ArcCatalog. ArcCatalog is a spatial data manager. It is possible to browse and analyze the contents of PostGRES databases using ArcCatalog. In my PostGRES database, I have a table called SF30001. I can fully interact with the table using PSQL and pgAdmin III. However, I cannot interact with the table at all using ArcCatalog. Full interactivity needs to happen with ArcCatalog because the majority of the users of the PostGRES database will be using ArcCatalog to access data in the PostGRES database.
If I execute a make table query along the lines of “select * into SF30001_test from SF30001” I can interact with the table in ArcCatalog just fine.
I suspect that what I am running into is an ArcSDE configuration setting but I am not sure which one. I am not ready to rule out the issue as a PostGRES issue either. I'm currently pouring over configuration settings and how-to documents, but I wonder if anybody has any recommendations on how to gain full interactivity with the original table in ArcCatalog.
Thanks,
Mike
