Edson Carlos Ericksson Richter wrote :
>
>MaxDB doesn't allow I add a column with not null attribute.
>But, reading docs, if I put a check constraint on it,
>automatically that
>column is not null; so by extension, if I need to add a column
>not null,
>I should use something like
>
>alter table tbx add cxe char(1) default 't' check cxe in ('t', 'f')
>
>?
>
>Or I misinterpreted docs?
>
>TIA,
>
>Edson Richter
>
>--
>Edson Carlos Ericksson Richter
>MGR Inform�tica Ltda.
>Fones: 3347-0446 / 9259-2993
>
If you append a column with not null, MaxDB must know the value to be inserted
for the existing rows of the table. You therefore must specify this value
as the default value :
alter table tbx add xce char(1) default 't' not null
should do.
Best Regards
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
