Heiko Giesselmann wrote:
>
> Hi,
>
> according to the documentation, 'ALTER TABLE sometable ADD
> PRIMARY KEY
> ( keycolumn )' should be valid syntax. Both in Oracle mode
> and Internal
> mode I get the error message:
> 'General error;-7002 POS(1) KEY not allowed.'
>
> Anybody any ideas?
>
> Thanks, Heiko
>
If there IS a user-defined primary key defined for the table, another
ALTER TABLE ADD PRIMARY KEY will fail.
Try to drop the existing primary key and THEN add the new one.
That should work.
Or did you try to use a LONG-column as primary key column? This is not possible.
Elke
SAP Labs Berlin
>
> --------------------------------------------------------------
> This mail has been inspected by Webwasher - leading technology
> for E-mail and Web Security.
>
> Webwasher - keeping your Web clean!
> --------------------------------------------------------------
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
