Skip site navigation (1) Skip section navigation (2)

Re: ALTER TABLE x ALTER COLUMN y TYPE z

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-docs(at)postgresql(dot)org>,"Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Date: 2006-03-22 20:01:13
Message-ID: 442158A9.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-docs
>>> On Wed, Mar 22, 2006 at  1:00 pm, in message
<200603221400(dot)33513(dot)xzilla(at)users(dot)sourceforge(dot)net>, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)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


In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2006-03-22 20:14:44
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Previous:From: Robert TreatDate: 2006-03-22 19:00:33
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group