Comments to www list

Are we going to continue to see all interactive document comments posted
to the www list?

---------------------------------------------------------------------------

nobody wrote:
> Author: Alex French <alexfrench@gmail.com>
> ----
> Note that pg does not support changing the type of a column. Instead, use something like the code below to change,
say,a varchar(32) into varchar(64) (assuming the collumn is called abc): 
>
> BEGIN;
> ALTER TABLE mytable ADD COLUMN abc_new varchar(64);
> UPDATE mytable SET abc_new = abc;
> ALTER TABLE mytable RENAME abc TO abc_old;
> ALTER TABLE mytable RENAME abc_new TO abc;
> COMMIT;
>
> If you're chaning the type of the column radically, you need to do more fancy type casting, but that's the theory.
> ----
> Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-alter.html
> Reject:      http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1966
> Edit:        http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1966
> Delete:      http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1966
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073