View Single Post

   
  #7 (permalink)  
Old 04-09-2008, 08:08 AM
Tom Lane
 
Posts: n/a
Default Re: Seeking a better PL/pgSQL editor-debugger

Tony Caduto <tony_caduto@amsoftwaredesign.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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote