Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> writes: > Another thing to keep in mind is if you restore a dump from 7.x to 8.x > it will not do any checking unless you make a tweak, see this article: > http://www.milwaukeesoft.com/forums/viewtopic.php?t=83 > As far as I know this affects 8.0 and 8.1, I am sure someone will > correct me if I am wrong :-) That is true in 8.0 but not anymore in 8.1. The reason we invented the "pg_pltemplate" catalog is to ensure that old dumps of PL language definitions will track desired changes without such manual heroics ... regards, tom lane
