Re: "stored procedures" - use cases? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: "stored procedures" - use cases?
Date
Msg-id 201105100019.p4A0J4Q11684@momjian.us
Whole thread Raw
In response to Re: "stored procedures" - use cases?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Kevin Grittner wrote:
> Peter Eisentraut <peter_e@gmx.net> wrote:
>  
> > what would be the actual use cases of any of these features? 
> > Let's collect some, so we can think of ways to make them work.
>  
> The two things which leap to mind for me are:
>  
> (1)  All the \d commands in psql should be implemented in SPs so
> that they are available from any client, through calling one SP
> equivalent to one \d command.  The \d commands would be changed to
> call the SPs for releases recent enough to support this.  Eventually
> psql would be free of worrying about which release contained which
> columns in which system tables, because it would just be passing the
> parameters in and displaying whatever results came back.
>  
> I have used products which implemented something like this, and
> found it quite useful.

Uh, why does this require stored procedures?  Seems our existing
function capabilities are even better suited to this.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unfriendly handling of pg_hba SSL options with SSL off
Next
From: Bruce Momjian
Date:
Subject: Re: "stored procedures" - use cases?