Skip site navigation (1) Skip section navigation (2)

Re: Seeking a better PL/pgSQL editor-debugger

From: "Ken Winter" <ken(at)sunward(dot)org>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'PostgreSQL pg-general List'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Seeking a better PL/pgSQL editor-debugger
Date: 2006-01-28 22:39:01
Message-ID: 002e01c6245b$a35d4360$6603a8c0@kenxp (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Tom ~

Thanks for the news.  I'm on PostgreSQL 7.4.7, alas, and there's nothing I
can do about it because it resides on a host that I don't control.  I
suppose if I don't find an alternative, I could move my development work to
a local installation of PostgreSQL 8.1.

~ Ken

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> 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" <ken(at)sunward(dot)org> 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
> out
> > the error was a missing ";" way back in line 53, and it took two days of
> > trial and error and staring at the code to find it.
> What Postgres version are you using?
> I would blame the backend more than the client tools for the failure to
> localize this syntax error.  We've made significant progress in 8.0
> and again in 8.1 on improving plpgsql's error messages --- if you are
> not on 8.1 the first thing to try is a backend upgrade.
> 			regards, tom lane

In response to

pgsql-general by date

Next:From: Doug McNaughtDate: 2006-01-28 22:58:01
Subject: Re: Viewing Database Scheme
Previous:From: Eric B. RidgeDate: 2006-01-28 21:22:35
Subject: Re: Viewing Database Scheme

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group