Mohd Radzi Ibrahim <[EMAIL PROTECTED]>
wrote:
Using ALTER TABLE to add a constraint or a new column marked as
PRIMARY KEY is not supported. You can get pretty much the same
effect by doing:
CREATE UNIQUE INDEX custsales_i ON custsales(id, type);
Dan.
Thanks for the suggestion. Will it still work for the REPLACE command
to identify indentical record?
Yes. REPLACE conflict resolution kicks in upon violation of any
uniqueness constraint.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
