Postgres Pro
Downloads
Home   >   mailing lists

Thread: More on the TO DO wishlist

More on the TO DO wishlist

From
Chris Ruprecht
Date:
I did some pl/pgsql this morning and forgot a ';' at the end of a line. The
result was, that the compiler complained about a wrong statement in line 304
- which is at the end of the program.
The other error I made was that I used a new record without defining the
record first. This, the program only detected, when it first tried to use
the new record (select into xxx * from yyy...).

Can the parser be changed to be a little more intelligent about it's error
reporting, and can it be changed to check if all variables, records, etc.
have been defined before the program runs?

Best regards,
Chris


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: More on the TO DO wishlist

From
"Josh Berkus"
Date:
Chris,

> Can the parser be changed to be a little more intelligent about it's
> error
> reporting,

This is on everybody's "todo" list.  According to Bruce and Jan at LWE,
though, better error reporting is not an easy fix.

> and can it be changed to check if all variables, records,
> etc.
> have been defined before the program runs?

Actually, I think this would be a role better served by an IDE.  I've
long thought that it would be teriffic if someone wrote a PL/whatever
IDE (covering PL/pgSQL, PL/sh, PLtcl and PLperl).  However, I can
neither fund nor write it myself, so that'll remain a "wish list" item
until maybe Red Hat sees money in it.

Speaking of which, does anyone know if RH has a seperate "wish list" for
what us developer-types would like to see our of RHDB?

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
Attachment

Re: More on the TO DO wishlist

From
Peter Eisentraut
Date:
Josh Berkus writes:

> Actually, I think this would be a role better served by an IDE.  I've
> long thought that it would be teriffic if someone wrote a PL/whatever
> IDE (covering PL/pgSQL, PL/sh, PLtcl and PLperl).

<fantasy>Given that Emacs has editing modes of varying sophistication for most/allof these languages, and XEmacs has a
built-inPostgreSQL client module,one could write a minor mode for PG procedural languages that quote-escapethe buffer
andload it into the server.  You heard it here first!
 
</fantasy>

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: More on the TO DO wishlist

From
"Josh Berkus"
Date:
Peter,

> <fantasy>
>  Given that Emacs has editing modes of varying sophistication for
> most/all
>  of these languages, and XEmacs has a built-in PostgreSQL client
> module,
>  one could write a minor mode for PG procedural languages that
> quote-escape
>  the buffer and load it into the server.  You heard it here first!
> </fantasy>

<pants-wetting nightmare>
Does this mean I'll be forced to learn Emacs?
</pants-wetting nightmare>

-Josh
(Who uses Kedit, Pico, and Joe)


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
Attachment