Convert postgres varchar[] to text[] without downtime
2
votes
2
answers
2602
views
As I discovered in researching [this question](https://dba.stackexchange.com/q/293904/112479) , converting a column from
varchar(100)[]
to text[]
requires a table rewrite and rebuilding indexes.
Is there a way to manage this conversion without the locking and rewriting through some catalog trickery like that used in [this question](https://stackoverflow.com/q/48693373/754254) ? Particularly interested in version 10 if possible
Asked by Felipe
(317 rep)
Jun 8, 2021, 02:39 AM
Last activity: Jun 9, 2021, 03:44 AM
Last activity: Jun 9, 2021, 03:44 AM