Caveats for altering field length via pgAdmin?

Question

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

Asrujit_SenGupta · Answer

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?

colinw · Answer

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

MichaelSnook · Answer

Thanks Colin

Will this work if the column is populated with data?

Mike