Re: Seeking a better PL/pgSQL editor-debugger - Mailing list pgsql-general

From Tom Lane
Subject Re: Seeking a better PL/pgSQL editor-debugger
Date
Msg-id 20241.1138490627@sss.pgh.pa.us
Whole thread Raw
In response to Re: Seeking a better PL/pgSQL editor-debugger  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Responses Re: Seeking a better PL/pgSQL editor-debugger
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating users per database
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: Viewing Database Scheme