| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2006-03-23 04:54:15 | Re: Online Backups: Minor Caveat, Major Addition? |
| Previous Message | Tom Lane | 2006-03-22 20:14:44 | Re: ALTER TABLE x ALTER COLUMN y TYPE z |