X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 86E259DC83C for ; Wed, 22 Mar 2006 16:01:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40538-03 for ; Wed, 22 Mar 2006 16:01:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 132629DC9D8 for ; Wed, 22 Mar 2006 16:01:32 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 22 Mar 2006 14:01:33 -0600 Message-Id: <442158A9.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0 Date: Wed, 22 Mar 2006 14:01:13 -0600 From: "Kevin Grittner" To: , "Robert Treat" Cc: "Tom Lane" Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z References: <44213BD5.EE98.0025.0@wicourts.gov> <200603221400.33513.xzilla@users.sourceforge.net> In-Reply-To: <200603221400.33513.xzilla@users.sourceforge.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.102 required=5 tests=[AWL=0.102] X-Spam-Score: 0.102 X-Spam-Level: X-Archive-Number: 200603/30 X-Sequence-Number: 3487 >>> On Wed, Mar 22, 2006 at 1:00 pm, in message <200603221400.33513.xzilla@users.sourceforge.net>, Robert Treat 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