nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Changing colomn length in egdb

yockee

I want to change colomn length for a feature class that is involved in feature service, web map and field map.

If I change the colomn length (increase the width) via PgAdmin, will it effect everything down the line ?

I am using Postgresql 13 with Arcgis enterprise 11.0

thanks

Encontre mais publicações marcadas com

Accepted answers

Asrujit_SenGupta

No, do not make any changes on the Feature Class schema directly from the database end. The enterprise geodatabase system tables are sensitive, and you can end up corrupting your data.

Also, is the data versioned?

Check the Alter Field tool.

All comments

HarryPlendl

I don't believe this would be the way I would do it. I have used Postgresql for about 6 years and anything Esri related I do through the tools. Except adding users and roles.

Add a new column in the data design of the feature class in ArcGIS Pro with the field length and type of data desired. Calculate the field with the values of the original field and then delete the original field.

Overwrite the service and this will be reflected in all the client apps. You have to overwrite the service as the owner of the service.

Asrujit_SenGupta

No, do not make any changes on the Feature Class schema directly from the database end. The enterprise geodatabase system tables are sensitive, and you can end up corrupting your data.

Also, is the data versioned?

Check the Alter Field tool.

ryanuthoff

After changing the column length, you will need to restart (or potentially republish) your feature service so the field length is updated there. But otherwise, yes, changing the column length in the EGDB will be reflected in everything down the line.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.