Re: Syntax error while altering col-type

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: Syntax error while altering col-type
Дата
Msg-id 20050113101923.GY14073@sam.samason.me.uk
обсуждение исходный текст
Ответ на Re: Syntax error while altering col-type  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
Список pgsql-sql
KÖPFERL Robert wrote:
>I'm a little bit perplexed now... is it really the case that pre 8.0 systems
>aren't able to change col-types?

I would guess that the column type altering code is just short hand
for creating a new column of the correct type, copying the old column
into the new one, deleting the old column, and renaming the new column
to be the same as the old one.

That is just a guess though!  But if it's all bundled inside a
transaction it should have about the same semantics, shouldn't it?

Cheers, Sam


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

Предыдущее
От: KÖPFERL Robert
Дата:
Сообщение: Re: Syntax error while altering col-type
Следующее
От: Dawid Kuroczko
Дата:
Сообщение: Columns into rows.