topic Re: Caveats for altering field length via pgAdmin? in Geodatabase Questions

Caveats for altering field length via pgAdmin?

MichaelSnook — Tue, 04 Jun 2019 20:39:45 GMT

Is there any danger in altering a field length in a PostGres DB using pgAdmin?

I was able to successfully alter both the main table as well as the adds table column name but I'm wondering if there are any possible ramifications concerning versioning etc? Thanks for any info in advanced!

Mike

Re: Caveats for altering field length via pgAdmin?

ColinWerle1 — Tue, 04 Jun 2019 20:58:26 GMT

Hi Mik,

Typically it is not recommended to follow this workflow because of the version view table. A possible workaround could be to un-register it as versioned in ArcMap, and use the field properties dialog box to change the field length, then re-register it as versioned again.

Best,

Colin

Re: Caveats for altering field length via pgAdmin?

MichaelSnook — Tue, 04 Jun 2019 21:31:06 GMT

Thanks Colin

Will this work if the column is populated with data?

Mike

Re: Caveats for altering field length via pgAdmin?

ColinWerle1 — Tue, 04 Jun 2019 23:54:46 GMT

Mike,

I just did some brief testing. What I found was that I am able to increase the field length when the table is unregistered as versioned, however, if I tried to decrease the field length I would be prompted with a "table or feature class is not empty" error.

Colin

Re: Caveats for altering field length via pgAdmin?

Asrujit_SenGupta — Sun, 09 Jun 2019 05:09:53 GMT

Expected documented behavior: Modifying field properties—ArcGIS Help | ArcGIS Desktop

Length
If your table or feature class does not contain data, you can increase or decrease this value. If your table or feature class contains data, you can only increase the field length.

Also, you can alter the field length, even when the data is Versioned. You don't need to Unregister as Versioned, to alter the field length.

FAQ: What schema changes can be made to versioned data?