| From: | Rolf Lüttecke <rolf(dot)luettecke(at)michael-telecom(dot)de> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Alter column / array |
| Date: | 2001-10-12 07:31:02 |
| Message-ID: | 007701c152ef$d8461ee0$8300a8c0@michaeltelecom.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rolf Lüttecke | 2001-10-12 07:46:10 | Intel C++ Compiler |
| Previous Message | Orion | 2001-10-11 21:14:33 | Index Scans Oddness |