Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> 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