-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Justin Julicher wrote:
If you use ALTER TABLE it will check every row in the table to make sure
the column doesn't exceed the constraint (in 8.4 - I know this has been
updated in 9.x)
Correct.
As I am trying to update a table with
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Justin Julicher asked:
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.
Not the only way - the canonical way is to
Hi Greg,
First off, thanks for your reply.
I had actually just read your blog before writing this.
I should have been more clear in my first post.
If you use ALTER TABLE it will check every row in the table to make sure
the column doesn't exceed the constraint (in 8.4 - I know this has been