Dave
You sure that's the right fix? We want to drop the "not null"
requirement, but keep the id column in place. We do that now with
this:
alter table rag_group_subscription drop id not null
Your suggestion for Oracle is this:
alter table rag_group_subscription drop primary key;
Which looks like it drops the primary key column entirely.
Well I ran this command, and then did a "desc rag_group_subscription" and it
shows all columns still present, but the id field no longer has "not null"
next to it.
I'm no Oracle expert, but I understand the "drop primary key" command to
mean that the primary key constraint is removed, but the column it applied
to is untouched. I'd feel more comfortable, though, if someone else who has
upgraded to 3.1 using Oracle 9 could confirm this worked for them.
I did try to run:
alter table rag_group_subscription modify id null
which is Oracle's way of removing a field's not null constraint, but Oracle
refused, saying that this would potentially violate a primary key constraint
(which automatically forbids nulls).
Jerry
_________________________________________________________________
Play your part in making history - Email Britain!
http://www.emailbritain.co.uk/
