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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073