| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-22 20:14:44 | Re: ALTER TABLE x ALTER COLUMN y TYPE z |
| Previous Message | Robert Treat | 2006-03-22 19:00:33 | Re: ALTER TABLE x ALTER COLUMN y TYPE z |