Ger Timmens <[email protected]> writes: > Can we change the definitions of all 'timestamp' columns > from 'timestamp without time zone' to timestamp with time stamp' > in slony (we are using 1.2.20 rightnow).
Sure, you could submit DDL requests via the slonik command EXECUTE SCRIPT <http://slony.info/documentation/1.2/stmtddlscript.html> The script would consist of a series of ALTER TABLE commands, one for each column to be thus altered. I suspect you'll find this to be a mighty expensive operation, as it: a) locks all the tables (in 1.2, ALL replicated tables, in 2.0, just the ones that need to be altered) for the duration, and b) fairly likely leads to the affected tables being rewritten, so all the old tuples are dead, so they need vacuuming rather badly. So, expensive, but it can certainly be done. -- let name="cbbrowne" and tld="afilias.info" in String.concat "@" [name;tld];; Christopher Browne "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
