Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Simon Riggs
On Tue, 2006-08-15 at 18:42 -0400, Tom Lane wrote: > I wrote: > > It'd definitely be nicer that way, but given the current limitations of > > bootstrap mode I see no non-kluge way to make a built-in function have > > OUT parameters. (Hint: array_in doesn't work in bootstrap mode.) > > Actually, t

Re: [PATCHES] pgbench: handring empty lines in external scripts

2006-08-15 Thread Tatsuo Ishii
Thanks. I have committed your patches. -- Tatsuo Ishii SRA OSS, Inc. Japan > Hi Tatsuo-san and folks, > > This is a fix in pgbench to handle empty lines in external scripts. > The manual says > | Empty lines and lines begging with "--" will be ignored. > but AFAICS, it cannot accept empty lines a

Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Tom Lane
I wrote: > It'd definitely be nicer that way, but given the current limitations of > bootstrap mode I see no non-kluge way to make a built-in function have > OUT parameters. (Hint: array_in doesn't work in bootstrap mode.) Actually, that turns out not to be so hard to fix as I thought. array_in o

Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > True, but making people parse the output of a function to seperate the > two fields seems pretty silly. Is there some reason why > pg_xlogfile_name_offset shouldn't be a SRF, or use two out parameters? It'd definitely be nicer that way, but given the cu

Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Jim C. Nasby
On Tue, Aug 15, 2006 at 07:11:24PM +0100, Simon Riggs wrote: > On Tue, 2006-08-15 at 12:13 -0500, Jim C. Nasby wrote: > > On Tue, Aug 15, 2006 at 06:07:12PM +0100, Simon Riggs wrote: > > > On Tue, 2006-08-15 at 11:10 -0400, Alvaro Herrera wrote: > > > > Simon Riggs wrote: > > > > > > > > > > > >

Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Simon Riggs
On Tue, 2006-08-15 at 12:13 -0500, Jim C. Nasby wrote: > On Tue, Aug 15, 2006 at 06:07:12PM +0100, Simon Riggs wrote: > > On Tue, 2006-08-15 at 11:10 -0400, Alvaro Herrera wrote: > > > Simon Riggs wrote: > > > > > > > > > > > > > postgres=# select pg_xlogfile_name_offset(pg_switch_xlog()); > > >

Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Jim C. Nasby
On Tue, Aug 15, 2006 at 06:07:12PM +0100, Simon Riggs wrote: > On Tue, 2006-08-15 at 11:10 -0400, Alvaro Herrera wrote: > > Simon Riggs wrote: > > > > > > > > > postgres=# select pg_xlogfile_name_offset(pg_switch_xlog()); > > > pg_xlogfile_name_offset > > >

Re: [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Simon Riggs
On Tue, 2006-08-15 at 11:10 -0400, Alvaro Herrera wrote: > Simon Riggs wrote: > > > > > postgres=# select pg_xlogfile_name_offset(pg_switch_xlog()); > > pg_xlogfile_name_offset > > --- > > 00010001 16777216 > > (1 row) > > > I've not taken

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > what issues might arise if the output is redirected to a legal tmp file? Well, (1) finding a place to put the temp file, ie a writable directory; (2) ensuring the file is removed afterwards; (3) not exposing the user to security hazards due to unsafe use

Re: [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Alvaro Herrera
Simon Riggs wrote: > postgres=# select pg_xlogfile_name_offset(pg_switch_xlog()); > pg_xlogfile_name_offset > --- > 00010001 16777216 > (1 row) > I've not taken up Jim Nasby's suggestion to make this an SRF with > multiple return rows/colum

[PATCHES] Partial Index wording as per BUG

2006-08-15 Thread Simon Riggs
Doc patch in response to bug raised: [BUGS] partial indexes not used on parameterized queries? 10 July 2006 -- Simon Riggs EnterpriseDB http://www.enterprisedb.com Index: doc/src/sgml/indices.sgml === RCS file:

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread Bruce Momjian
Andreas Pflug wrote: > Bruce Momjian wrote: > > Andreas Pflug wrote: > >> Tom Lane wrote: > >>> Andrew Dunstan <[EMAIL PROTECTED]> writes: > >>> > I am more than somewhat perplexed as to why the NUL device should be a > security risk ... what are they thinking?? > > >>> Frank

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread Andreas Pflug
Bruce Momjian wrote: > Andreas Pflug wrote: >> Tom Lane wrote: >>> Andrew Dunstan <[EMAIL PROTECTED]> writes: >>> I am more than somewhat perplexed as to why the NUL device should be a security risk ... what are they thinking?? >>> Frankly, I don't believe it; even Microsoft

Re: [PATCHES] Forcing current WAL file to be archived

2006-08-15 Thread Simon Riggs
On Fri, 2006-08-11 at 08:04 +0100, Simon Riggs wrote: > On Thu, 2006-08-10 at 08:57 -0400, Tom Lane wrote: > > > Anyway, after further thought I've concluded that we really should > > supply something that returns the Insert pointer, as this would be > > useful for debugging and system-monitoring

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread Bruce Momjian
Andreas Pflug wrote: > Tom Lane wrote: > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > > >> I am more than somewhat perplexed as to why the NUL device should be a > >> security risk ... what are they thinking?? > >> > > > > Frankly, I don't believe it; even Microsoft can't be that stupid

Re: [HACKERS] [PATCHES] [Patch] - Fix for bug #2558, InitDB failed

2006-08-15 Thread dror
Hi All,   I agree with all of you that it is strange behavior, more then that : On two win 2003 machines with the same SP and last hot fixes, on one the nul device is accessible by non admin user and on other it is not. I also agree that the source of the problem might be  something that effect t

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread Andreas Pflug
Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> I am more than somewhat perplexed as to why the NUL device should be a >> security risk ... what are they thinking?? >> > > Frankly, I don't believe it; even Microsoft can't be that stupid. > And I can't find any suggestion t

[PATCHES] pgbench: handring empty lines in external scripts

2006-08-15 Thread ITAGAKI Takahiro
Hi Tatsuo-san and folks, This is a fix in pgbench to handle empty lines in external scripts. The manual says | Empty lines and lines begging with "--" will be ignored. but AFAICS, it cannot accept empty lines and exit with error. The cause seems to be the usage of isspace(). The characters assum

Re: [PATCHES] [Patch] - Fix for bug #2558, InitDB failed to run

2006-08-15 Thread dror
Hi Andrew, Regarding to your comments: > 1. a patch is generated by the program "diff"I will do it ,if needed> 2. before we do anything, as Tom Lane says, we need verification of the > problem, preferably in writing from Microsoft.I do understand that, but,  de-facto, the current implementati