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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
