Re: Change type - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Change type
Date
Msg-id Pine.GSO.4.61.0501182124510.12633@ra.sai.msu.su
Whole thread Raw
In response to Change type  ("Vladimir S. Petukhov" <vladimir@sycore.org>)
List pgsql-general
This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

---559023410-538851280-1106072734=:12633
Content-Type: TEXT/PLAIN; charset=koi8-r; format=flowed
Content-Transfer-Encoding: 8BIT

On Tue, 18 Jan 2005, Vladimir S. Petukhov wrote:

> Hi!
> Sorry for my English..
> I want to dinamcly change type of column. If possible, of course.Trivial idia - create new temporary column, try to
writevalue from old columt to temporarity (if type conersion ok - this made using select/update command and type
conversionchecks on client's side), then delete old column, and rename temporary column.. But this decision looked
quiteill... 
> Do you have better idea?

hmm,

you may use generic type like 'varchar' to store your data

> -- Я доcтаю из шиpоких штанин,В котоpых гpажданка одета,Воcемь ноpмальных. И двадцать одинЗапpещенных к ношенью
пpедмета!
> Now playing: 03 - Lara And Reyes - Exotico.mp3   AutoGenerated by fortune & xmms...
> ---------------------------(end of broadcast)---------------------------TIP 9: the planner will ignore your desire to
choosean index scan if your      joining column's datatypes do not match 
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---559023410-538851280-1106072734=:12633--

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Backup strategy
Next
From: Chris
Date:
Subject: DBD::Pg behavior for large queries