Re: viewing source code - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: viewing source code
Date
Msg-id 20071220114011.64a650d7@commandprompt.com
Whole thread Raw
In response to Re: viewing source code  ("Trevor Talbot" <quension@gmail.com>)
Responses Re: viewing source code
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 20 Dec 2007 10:47:53 -0800
"Trevor Talbot" <quension@gmail.com> wrote:

> 
> > This "feature" as it is called can be developed externally and has
> > zero reason to exist within PostgreSQL. If the feature has the
> > level of demand that people think that it does, then the external
> > project will be very successful and that's cool.
> 
> I'm unsure of what you consider "external" here. Is SE-PostgreSQL the
> type of thing you mean?

I don't know that it needs to be that extensive. I noted elsewhere in
the thread the idea of a plpgsql_s. I think that is an interesting
idea. I just don't think it needs to be incorporated into
postgresql-core. 

If we were to remove viewing source from postgresql-core an interesting
possibility would be to remove prosrc from pg_proc altogether. Instead
prosrc becomes a lookup field to the prosrc table.

The prosrc table would only be accessible from a called function (thus
you can't grab source via select). Of course this wouldn't apply to
superusers but any normal user would not be able to so much as look
sideways at the prosrc table.

Sincerely,

Joshua D. Drake





- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHasUbATb/zqfZUUQRAqINAJsFpvPkUJ6oL/gH7dX4YLsbldIC4gCfdujh
/S2b/ZmQU+R54MlO5ATelns=
=+2Ut
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: viewing source code
Next
From: "Roberts, Jon"
Date:
Subject: Re: viewing source code