From: Robert Treat <xzilla@users.sourceforge.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Date: Wed, 22 Mar 2006 16:50:20 -0500
User-Agent: KMail/1.8.3
Cc: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>, pgsql-docs@postgresql.org
References: <44213BD5.EE98.0025.0@wicourts.gov>
	<442158A9.EE98.0025.0@wicourts.gov>
	<19259.1143058484@sss.pgh.pa.us>
In-Reply-To: <19259.1143058484@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200603221650.21203.xzilla@users.sourceforge.net>

On Wednesday 22 March 2006 15:14, Tom Lane wrote:
> However, the arguments Robert pointed to had to do with concurrent
> access to the table, and somehow I am not seeing the use-case for ALTER
> COLUMN TYPE on a table that's being actively used by other clients.
> It seems unlikely that you could do that without needing to also update
> your client software. 

Altering between char and text or some such? Or something like INET to TEXT. 
(Not that it matters for the things being discussed here, but I think there 
are cases)

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL