I have an html and django based application that has an extensive user interface that allows users and administrators to capture things like usernames, projectids, organizations, treatment types, etc that are used as look up tables for the GIS layers. All of these tables are stored in the public schema. The user application interfaces the public schema tables as picklist for the features that get entered. All of the GIS stuff is in the SDE schema. We use SQL insert commands to insert data into the point and polygon features classes. All of this is working fine. Using ArcMap I can see and draw the layers correctly. Using PGAdmin, I can see and access the public schema files just fine.
The problem is I need to be able to use ArcMap and Catalog to look at the data together. This will require me to join the public schema tables to the SDE feature class layers so I can see the true values for the fields rather than the codes that are actually stored in the feature classes. I can't seem to figure out how to access the public schema tables through ArcCatalog. I can see them just fine, but can not access them. If I try to get the properties of one of the public schema tables it says: "Failed to edit selected object(s). DBMS table not found"
I have tried changing the owner of those table to sde through PGAdmin, but that does help.
I know if I had to do this over, I would have written the GIS stuff to the public schema, but its too late for that now, or at least that's what I am thinking now.
Any ideas?