Re: ALTER TABLE x ALTER COLUMN y TYPE z

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: ALTER TABLE x ALTER COLUMN y TYPE z
Дата
Msg-id 442158A9.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: ALTER TABLE x ALTER COLUMN y TYPE z  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: ALTER TABLE x ALTER COLUMN y TYPE z  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
>>> On Wed, Mar 22, 2006 at  1:00 pm, in message
<200603221400.33513.xzilla@users.sourceforge.net>, Robert Treat
<xzilla@users.sourceforge.net> wrote:
>
> I believe Tom's comments in this email apply similarly here.
> http://archives.postgresql.org/pgsql- general/2006- 03/msg00891.php

The user comment's recommended technique includes this line:

ALTER TABLE tab DROP COLUMN temp_name;

Would this cause a table rewrite?  (Not a rhetorical question.  I
really don't know.)

> Feel free to submit an additional doc comment.

I did, but it was rejected -- presumably because it included a
question.  Once I have a better handle on the issue, if it seems like it
needs it, I'll try again.

-Kevin


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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER TABLE x ALTER COLUMN y TYPE z