topic Re: gdb_items table can't see joined columns in Geodatabase Questions

gdb_items table can't see joined columns

deleted-user-0W0-oLHxDjCX — Thu, 05 Jan 2017 12:58:32 GMT

Hello everyone

After have made a materialized join on a feature class I was looking for some update on gdb_items within PostgreSQL but I just saw the very old structure before the join on PostgreSQL.

Could someone tell me if there is any command that must be done to update this table in a way I could make changes (I.E: On my alias within the description field)?

Best regards

Ezequias

Re: gdb_items table can't see joined columns

George_Thompson — Thu, 05 Jan 2017 14:58:09 GMT

I am not sure that you will see any information in the gdb_items table on a "joined" field to a feature class or object listed. The gdb_items table is specifically for the geodatabase repository table. Joins either persist in a map document or in a SQL view (DB view).

Look at the fields for the gdb_items table in PostgreSQL: System tables of a geodatabase in PostgreSQL—Help | ArcGIS Desktop

The only way to update this table, correctly and more importantly safely, is via an ArcGIS client (UI or Python)

Let me know if I missed what you are asking.

https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=dadd81d2-230f-4b8d-b8a5-93da5368e850&searchIndex=0‌

Re: gdb_items table can't see joined columns

deleted-user-0W0-oLHxDjCX — Thu, 05 Jan 2017 16:22:51 GMT

Dear George

I think you got the point. The more secure way to perform any changes of a Geodatabase structure (schema,alias,etc) is via ArcGIS Desktop or via Python.

I am sad about that because even on ArcGIS Desktop or on Portal this procedure is too slow if you have many elements to configure.

Anyway. Thank you so much for your information.

Sincerely

Ezequias

Re: gdb_items table can't see joined columns

George_Thompson — Thu, 05 Jan 2017 17:12:11 GMT

The main reason for way to make changes in the gdb_items table or really any geodatabase system table via an ArcGIS client is due to the dependencies in other system tables for each record.

I can tell you from personal experience and helping our customers, that some people make modifications to these tables incorrectly and it will corrupt the entire geodatabase with no way to recover, unless you have a backup from before the change was made.