| Lists: | pgsql-general |
|---|
| From: | frank_lupo <frank_lupo(at)email(dot)it> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | alter table change type column |
| Date: | 2003-03-24 09:54:35 |
| Message-ID: | HC8ZIZ$3376F76CFB92DE7C793719F6EC349EB1@email.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | frank_lupo <frank_lupo(at)email(dot)it> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: alter table change type column |
| Date: | 2003-03-24 16:30:06 |
| Message-ID: | 200303241630.h2OGU6406257@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | frank_lupo <frank_lupo(at)email(dot)it>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: alter table change type column |
| Date: | 2003-03-24 17:04:00 |
| Message-ID: | 3E7F3A80.4040905@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
>>
>
>
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | gearond(at)cvc(dot)net |
| Cc: | "frank_lupo" <frank_lupo(at)email(dot)it>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: alter table change type column |
| Date: | 2003-03-24 17:16:58 |
| Message-ID: | 200303241716.h2OHGwZ11997@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | frank_lupo <frank_lupo(at)email(dot)it>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: alter table change type column |
| Date: | 2003-03-24 17:26:13 |
| Message-ID: | 3E7F3FB5.4050904@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
>>>>
>>>
>>>
>>
>
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | gearond(at)cvc(dot)net |
| Cc: | "frank_lupo" <frank_lupo(at)email(dot)it>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: alter table change type column |
| Date: | 2003-03-24 17:27:31 |
| Message-ID: | 200303241727.h2OHRVk13075@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073