Re: Help with ADD COLUMN

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Help with ADD COLUMN
Дата
Msg-id 025801c293f9$11bbdf20$6500a8c0@internal
обсуждение исходный текст
Ответ на Help with ADD COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Help with ADD COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > The one big programming difficulty I see is the process of running
through
> > all the existing tuples in the relation the column was added to and
> > evaluating the default for each row.
>
> Basically you wanna do an "UPDATE tab SET col = <default expr>".  I'd
> suggest letting the existing machinery handle as much of that as
> possible.

Using SPI calls?

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: 7.3RC2 please
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Help with ADD COLUMN