Rod Taylor <rbt(at)rbt(dot)ca> writes:
> I've been fiddling away on ALTER TABLE and have a few questions about a
> possible datatype change. Just alter portions.
> I presume I'll need to do a table rewrite. What is the best way to
> change a single datum? heap_modify() takes a single relation type where
> I will need to deal with different types. Simply build a new tuple with
> old datums (easy enough)? Do we care about OIDs being renumbered?
Have you consulted the archives? ISTM we discussed these issues to
death a year or two back.
regards, tom lane