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 ...
Tom,
Thanks for the info, I will update my article to reflect that.
--
Tony Cadut
PG Lightning does Code Completion. I don't think there is a frontend
tool that can step through a PL/pgSQL function.
Ben
""Ken Winter"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]...
Is a better PL/pgSQL editor /
debugger than pgAdmin III or phpPgAdmin available a
Tony Caduto <[EMAIL PROTECTED]> 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
Ken
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 28, 2006 1:26 PM
> To: Ken Winter
> Cc: PostgreSQL pg-general List
> Subject: Re: [GENERAL] Seeking a better PL/pgSQL editor-debugger
>
> "Ken Winter" <[EMAIL PROTE
There is a better editor available:
http://www.amsoftwaredesign.com
http://www.amsoftwaredesign.com/lightning_admin.php
I invite you to try it out :-)
It provides all the find/replace goto line number etc, many of the
features of a IDE such as Delphi 2006 or VS, it also has super nice
tabbed b
On 28 Jan 2006 at 13:16, Ken Winter wrote:
> I've learned that pgAdmin "syntax error" can mean anything from a
> missing ";" to a faulty block structure to an undeclared variable to. I
AFAIK, the error messages you're seeing are generated by the database
backend and not by pgAdmin - pgAdmin simp
"Ken Winter" <[EMAIL PROTECTED]> writes:
> I ask because I was stuck for two days on the following error message:
> ERROR: syntax error at or near "LOOP"
> CONTEXT: compile of PL/pgSQL function "gen_history" near line 126
> and neither of those tools offered any more help than that. It turned ou
Is a better PL/pgSQL editor / debugger than pgAdmin III or
phpPgAdmin available anywhere?
I ask because I was stuck for two days on the following
error message:
ERROR: syntax error at or near "LOOP"
CONTEXT: compile of PL/pgSQL function "gen_history"
near line 126
…and neithe
