Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to "add" columns - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Best way to "add" columns
Date
Msg-id Pine.LNX.4.21.0005151900080.349-100000@localhost.localdomain
Whole thread Raw
List pgsql-general
Tree view 
Jesse Scott writes:

> It would appear that ADD COLUMN was implemented by 6.5.x but when I tried
> "ALTER TABLE members ALTER COLUMN server SET DEFAULT 0;" it told me that
> that feature hadn't be implemented yet.

It is now.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: rtree indexes aren't being used with 7.0
Next
From: Jeff Hoffmann
Date:
Subject: Re: rtree indexes aren't being used with 7.0