View Single Post

   
  #4 (permalink)  
Old 04-11-2008, 04:36 AM
Michael Fuhr
 
Posts: n/a
Default Re: accessing postgres conf from stored procedure

On Mon, Jun 27, 2005 at 04:37:11PM +0200, strk wrote:
> On Mon, Jun 27, 2005 at 08:55:50AM -0400, Dave Cramer wrote:
> > you can use show xxx to show configuration values
> >
> > http://www.postgresql.org/docs/7.4/i.../sql-show.html

>
> No direct interface for shared libs ?


I don't know if it's fair game, but GetConfigOptionByName() (declared
in utils/guc.h) appears to work. Can any of the developers comment
on whether it's appropriate for user-defined code to call this
function?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote