Re: Alter column / array

Hi Tom,

> You can use ALTER TABLE SET DEFAULT to add the default after you add
> the column.
Works.

> Hmm ... I wonder why ADD COLUMN doesn't just call the SET DEFAULT
> routine to handle adding the default ...
I'm wondering too. But all programs do only those things they were told
to do - mostly, not always ;-)

Hi Stephan,

> And, what do you mean by updates doing strange things?
Follow-up-errors caused by updating an uninitialized array. Now it is
clear why it couldn't work.

Thanx and regards

R. Lüttecke (IT)

MICHAELTELECOM AG
Bruchheide 34
49163 Bohmte
+49 5471 8060
http://www.michael-telecom.de