pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
More on the TO DO wishlist
4+ messages / 3 participants
[nested] [flat]

* More on the TO DO wishlist
@ 2001-09-03 18:06  Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Chris Ruprecht @ 2001-09-03 18:06 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: More on the TO DO wishlist
@ 2001-09-03 19:39  Josh Berkus <josh@agliodbs.com>
  parent: Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2001-09-03 19:39 UTC (permalink / raw)
  To: Chris Ruprecht <chrup999@yahoo.com>; pgsql-sql

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







^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: More on the TO DO wishlist
@ 2001-09-03 21:24  Peter Eisentraut <peter_e@gmx.net>
  parent: Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Peter Eisentraut @ 2001-09-03 21:24 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: Chris Ruprecht <chrup999@yahoo.com>; pgsql-sql

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/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>

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: More on the TO DO wishlist
@ 2001-09-04 03:16  Josh Berkus <josh@agliodbs.com>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2001-09-04 03:16 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql

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







^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-09-04 03:16 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-03 18:06 More on the TO DO wishlist Chris Ruprecht <chrup999@yahoo.com>
2001-09-03 19:39 ` Josh Berkus <josh@agliodbs.com>
2001-09-03 21:24   ` Peter Eisentraut <peter_e@gmx.net>
2001-09-04 03:16     ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox