Re: [PATCHES] pt_BR FAQ updated

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Euler Taveira de Oliveira wrote: > Hi, > > Attached is a patch to up to date the brazilian FAQ. I included some > typo fixes too. > > Please apply. > > PS> Do not consider the last patch I sen

Re: [PATCHES] [BUGS] solaris non gcc compiler debug options

2004-12-02 Thread Bruce Momjian
OK, I see now. I backed out my previous patch and did one so Solaris has no optimization for debug. Patch attached. --- Kris Jurka wrote: > > > On Sat, 27 Nov 2004, Bruce Momjian wrote: > > > Kris Jurka wrote: > > > >

[PATCHES] Docs - Plpgsql trigger example auditing changes into another table

2004-12-02 Thread Mark Kirkwood
This patch adds another plpgsql trigger example to the chapter. It uses the emp table again, but shows how to audit changes into another table (emp_audit). I think this is a beneficial addition as our developers here were confused about how to write more complex triggers that used the special

Re: [PATCHES] Docs - Plpgsql trigger example auditing changes into another table

2004-12-02 Thread Tom Lane
Mark Kirkwood <[EMAIL PROTECTED]> writes: > This patch adds another plpgsql trigger example to the chapter. It uses > the emp table again, but shows how to audit changes into another table > (emp_audit). Should be an AFTER trigger, else you may be recording the wrong data, or even an event that

Re: [PATCHES] Docs - Plpgsql trigger example auditing changes into

2004-12-02 Thread Mark Kirkwood
Tom Lane wrote: Mark Kirkwood <[EMAIL PROTECTED]> writes: This patch adds another plpgsql trigger example to the chapter. It uses the emp table again, but shows how to audit changes into another table (emp_audit). Should be an AFTER trigger, else you may be recording the wrong data, or ev

Re: [PATCHES] contrib/xml2: add function xml_encode_special_chars

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Markus Bertheau wrote: > Hi, > > attached is a patch that adds the function xml_encode_special_chars to > the xml2 contrib module. It's against 8.0beta4. It's intended for > commit. > > I would

Re: [PATCHES] win32 ps info

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Magnus Hagander wrote: > On win32, there is currently no way to get the equivalent function of > the "ps" argument list on Unix - meaning that there is no way to > identify for example the stats

Re: [PATCHES] Archiver restart timer

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Simon Riggs wrote: > On Sun, 2004-11-21 at 23:07, Simon Riggs wrote: > > I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL from 60 > > seconds to 10 seconds. The original number was p

Re: [PATCHES] Unicode characters above 0x10000 #2

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- John Hansen wrote: > 3 times lucky? > > Last one broke utf8 G > > This one works, Too tired, sorry for the inconvenience.. > > ... John Content-Description: cvs.diff [ Attachment

Re: [PATCHES] SQL conformance related patch

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Troels Arvin wrote: > On Sat, 27 Nov 2004 22:27:13 +0100, Peter Eisentraut wrote: > > > I have installed your patch and adjusted the names of the standards > > throughout to the spellings sugge

Re: [PATCHES] [pgsql-hackers-win32] [BUGS] pg_autovacuum in 8beta-dev3 small bug

2004-12-02 Thread Bruce Momjian
Patch applied. Thanks. --- Dave Page wrote: > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf > > Of Bruce Momjian > > Sent: 27 November 2004 04:33 > > To: [EMAIL P

Re: [PATCHES] [HACKERS] Open Items

2004-12-02 Thread Bruce Momjian
I am going to discard these emails. We haven't solve the Win32 terminal server problem and I think it needs to be moved to the TODO list instead. --- Zeugswetter Andreas DAZ SD wrote: > > > o fix shared memory on Win2k

Re: [PATCHES] [HACKERS] libpq and psql not on same page about SIGPIPE

2004-12-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, patch applied. I also documented an optimmization we might make > leter in fe-secure.c: > n = send(conn->sock, ptr, len, 0); > /* > * Possible optimization: if sigpending() turns out to be an > * expensive operat

Re: [PATCHES] [HACKERS] libpq and psql not on same page about SIGPIPE

2004-12-02 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, patch applied. I also documented an optimmization we might make > > leter in fe-secure.c: > > > n = send(conn->sock, ptr, len, 0); > > /* > > * Possible optimization: if sigpending() turns out to be an

Re: [PATCHES] [HACKERS] multiline CSV fields

2004-12-02 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > + if (!embedded_line_warning && (c == '\n' || c == '\r') ) > + { > + embedded_line_warning = true; > + elog(WARNING, > + "CSV fields with embedded linefeed or c

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-12-02 Thread Christopher Kings-Lynne
I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines as causing significant confusion during restore, which is the last thing we want to do. I think that judgment is exactly backward. *Not* having timelines is what will cause seri

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-12-02 Thread Christopher Kings-Lynne
Please ignore- seems some old mail of mine got sent waaay late... Christopher Kings-Lynne wrote: I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines as causing significant confusion during restore, which is the last thing we want