Psql Version: 8.4
Hi,
We need to widen a column on a table with millions of rows and the only way to do this currently is to migrate the data from one column to another with a script and trigger.
I know how to do this via an update to pg_attribute which would incur the table scan penalty but I have a number of questions is –
- Does postgres pick up this change straight away?
- Are there any caveats to my first question?
thanks,
Justin