Rod Taylor <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html