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

Re: ALTER TABLE x ALTER COLUMN y TYPE z

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-docs(at)postgresql(dot)org
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Date: 2006-03-22 21:50:20
Message-ID: 200603221650.21203.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-docs
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

In response to

pgsql-docs by date

Next:From: Thomas F. O'ConnellDate: 2006-03-23 04:54:15
Subject: Re: Online Backups: Minor Caveat, Major Addition?
Previous:From: Tom LaneDate: 2006-03-22 20:14:44
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z

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