Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-19 Thread Peter Eisentraut
Joe Conway writes: I'm wondering whether it would be a good thing or a bad thing to have unrecognized settings found in postgresql.conf be registered as user defined settings? Certainly bad, since all error checking would go away. This is one of the main reasons why registering settings at

[HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Joe Conway
I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future feature: /* * Build the sorted array. This is split out so that it could be * re-executed after

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Gavin Sherry
On Wed, 18 Dec 2002, Joe Conway wrote: I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future feature: /* * Build the sorted array. This is

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future feature: It's fairly clear how the mechanisms for this

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Joe Conway
Tom Lane wrote: Joe Conway [EMAIL PROTECTED] writes: I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future feature: It's fairly clear how the

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Bruce Momjian
What exactly can you do with these variables other than SHOW/SET. Seems it would be nice if they could be used in queries, like in a special table like sysvar: SELECT sysvar.fsync; --- Joe Conway wrote: I've been

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Mike Mascari
- Original Message - From: Gavin Sherry [EMAIL PROTECTED] To: Joe Conway [EMAIL PROTECTED] On Wed, 18 Dec 2002, Joe Conway wrote: I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Gavin Sherry
On Wed, 18 Dec 2002, Bruce Momjian wrote: What exactly can you do with these variables other than SHOW/SET. Seems it would be nice if they could be used in queries, like in a special table like sysvar: SELECT sysvar.fsync; Isn't that just identical to having a table? Gavin

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Joe Conway
Gavin Sherry wrote: On Wed, 18 Dec 2002, Bruce Momjian wrote: What exactly can you do with these variables other than SHOW/SET. Seems it would be nice if they could be used in queries, like in a special table like sysvar: SELECT sysvar.fsync; Isn't that just identical to having a table?