Thread: alter table change type column
Is possible to alter table change type of column? Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-----ooo--- -- Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f Sponsor: Conto Arancio, il migliore amico dei tuoi risparmi. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3
No, we have not implemented that. You can add a column, copy the data over from the old column, then drop the old column and rename the new column. --------------------------------------------------------------------------- =?iso-8859-1?Q?frank=5Flupo?= wrote: > Is possible to alter table change type of column? > > > Bye !! > Frank Lupo (Wolf) !! > > /\_ _/\ > \ o o / > --ooo-----ooo--- > > > > -- > Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f > > Sponsor: > Conto Arancio, il migliore amico dei tuoi risparmi. > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- 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
And then redo all the triggers and indexes also? Bruce Momjian wrote: > No, we have not implemented that. You can add a column, copy the data > over from the old column, then drop the old column and rename the new > column. > > > --------------------------------------------------------------------------- > > =?iso-8859-1?Q?frank=5Flupo?= wrote: > >>Is possible to alter table change type of column? >> >> >>Bye !! >>Frank Lupo (Wolf) !! >> >> /\_ _/\ >> \ o o / >>--ooo-----ooo--- >> >> >> >>-- >>Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f >> >>Sponsor: >>Conto Arancio, il migliore amico dei tuoi risparmi. >>Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3 >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 6: Have you searched our list archives? >> >>http://archives.postgresql.org >> > >
Yes, afraid so. --------------------------------------------------------------------------- Dennis Gearon wrote: > And then redo all the triggers and indexes also? > > Bruce Momjian wrote: > > No, we have not implemented that. You can add a column, copy the data > > over from the old column, then drop the old column and rename the new > > column. > > > > > > --------------------------------------------------------------------------- > > > > =?iso-8859-1?Q?frank=5Flupo?= wrote: > > > >>Is possible to alter table change type of column? > >> > >> > >>Bye !! > >>Frank Lupo (Wolf) !! > >> > >> /\_ _/\ > >> \ o o / > >>--ooo-----ooo--- > >> > >> > >> > >>-- > >>Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f > >> > >>Sponsor: > >>Conto Arancio, il migliore amico dei tuoi risparmi. > >>Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3 > >> > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 6: Have you searched our list archives? > >> > >>http://archives.postgresql.org > >> > > > > > > -- 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
BTW, do the functions and indexes automatically get dropped if they are referencing a column that gets dropped? Bruce Momjian wrote: > Yes, afraid so. > > --------------------------------------------------------------------------- > > Dennis Gearon wrote: > >>And then redo all the triggers and indexes also? >> >>Bruce Momjian wrote: >> >>>No, we have not implemented that. You can add a column, copy the data >>>over from the old column, then drop the old column and rename the new >>>column. >>> >>> >>>--------------------------------------------------------------------------- >>> >>>=?iso-8859-1?Q?frank=5Flupo?= wrote: >>> >>> >>>>Is possible to alter table change type of column? >>>> >>>> >>>>Bye !! >>>>Frank Lupo (Wolf) !! >>>> >>>> /\_ _/\ >>>> \ o o / >>>>--ooo-----ooo--- >>>> >>>> >>>> >>>>-- >>>>Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f >>>> >>>>Sponsor: >>>>Conto Arancio, il migliore amico dei tuoi risparmi. >>>>Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3 >>>> >>>> >>>>---------------------------(end of broadcast)--------------------------- >>>>TIP 6: Have you searched our list archives? >>>> >>>>http://archives.postgresql.org >>>> >>> >>> >> >
Uh, indexes get dropped, I think. I am not sure about functions --- I don't think so because we don't always know what columns are referenced in a function. --------------------------------------------------------------------------- Dennis Gearon wrote: > BTW, do the functions and indexes automatically get dropped if they are > referencing a column that gets dropped? > > Bruce Momjian wrote: > > Yes, afraid so. > > > > --------------------------------------------------------------------------- > > > > Dennis Gearon wrote: > > > >>And then redo all the triggers and indexes also? > >> > >>Bruce Momjian wrote: > >> > >>>No, we have not implemented that. You can add a column, copy the data > >>>over from the old column, then drop the old column and rename the new > >>>column. > >>> > >>> > >>>--------------------------------------------------------------------------- > >>> > >>>=?iso-8859-1?Q?frank=5Flupo?= wrote: > >>> > >>> > >>>>Is possible to alter table change type of column? > >>>> > >>>> > >>>>Bye !! > >>>>Frank Lupo (Wolf) !! > >>>> > >>>> /\_ _/\ > >>>> \ o o / > >>>>--ooo-----ooo--- > >>>> > >>>> > >>>> > >>>>-- > >>>>Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f > >>>> > >>>>Sponsor: > >>>>Conto Arancio, il migliore amico dei tuoi risparmi. > >>>>Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=668&d=24-3 > >>>> > >>>> > >>>>---------------------------(end of broadcast)--------------------------- > >>>>TIP 6: Have you searched our list archives? > >>>> > >>>>http://archives.postgresql.org > >>>> > >>> > >>> > >> > > > > -- 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