Re: Advice regarding configuration parameters

Peter Eisentraut wrote:
> Am Freitag, 6. Februar 2004 10:27 schrieb Thomas Hallgren:
> > I would like some configuration parameters to Pl/Java and I would like some
> > advice. Where should they go?
> >
> > 1. Something similar to postgresql.conf (it's not extendable though, is
> > it?)
> 
> No, it is not.
> 
> > 2. A Table in the database in the "sqlj" schema
> 
> That could be an OK solution if you don't need to read the values every time.
> 
> > 3. Java properties file (cumbersome, must be available prior to starting
> > the JVM)
> 
> Yes, probably too cumbersome.
> 
> > 4. Some other place that is obvious but not currently known to me
> 
> I have been thinking for some time about a generic mechanism to configure 
> procedural languages.  It could be a text array in pg_language that you could 
> fill at will.  That way, it would be easily available to the language handler 
> or the actual function.  Of course, this is still only marginally better than 
> a regular table in your own schema.

One big question is whether the per-language variables are per-server or
per-database.  The might determine if you want them in the database or
in a configuration file.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073