Why do I have to use FOUR queries to accomplish the same result I can get from MySQL with only ONE query:
alter table users add column $ColumnName text; alter table users alter column $ColumnName set default ''; update users set t_shirt_size='' where $ColumnName is null; alter table users alter column $ColumnName set not null;
Wow, that's true!
On MySQL 4.0.16-nt is also possible write:
alter table T1 add CONSTRAINT FK_test foreign key (id) REFERENCES T2 (id);
that doesn't complain. Unfortunately repeating the command N times doesn't complain neither. And the funny here is that FK are not yet supported !
No regards. Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
