Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > On these questions, we have to find out how Oracle handles it, but > > your approach seems appropriate. > > I don't think Oracle even has that. But personally I'd like to see > errors for invalid pattern combinations. What do we do with other i

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> I don't think Oracle even has that. But personally I'd like to see >> errors for invalid pattern combinations. > What do we do with other invalid pattern combinations in to_char() now? Mostly, we return bogus results :-(. T

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Peter Eisentraut wrote: > >> I don't think Oracle even has that. But personally I'd like to see > >> errors for invalid pattern combinations. > > > What do we do with other invalid pattern combinations in to_char() now? > > Mostly,

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Brendan Jurd
On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Peter Eisentraut wrote: > >> I don't think Oracle even has that. But personally I'd like to see > >> errors for invalid pattern combinations. > > > What do we do with other invali

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Bruce Momjian
Brendan Jurd wrote: > On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > Peter Eisentraut wrote: > > > >> I don't think Oracle even has that. But personally I'd like to see > > > >> errors for invalid pattern combination

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Bruce Momjian
Bruce Momjian wrote: > Brendan Jurd wrote: > > On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > Tom Lane wrote: > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > Peter Eisentraut wrote: > > > > >> I don't think Oracle even has that. But personally I'd like to see > > > > >> err

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Brendan Jurd
On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: Bruce Momjian wrote: > Brendan Jurd wrote: > > On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > Tom Lane wrote: > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > Peter Eisentraut wrote: > > > > >> I don't think Oracle even h

Re: [PATCHES] [GENERAL] ISO week dates

2007-02-14 Thread Bruce Momjian
Brendan Jurd wrote: > On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Bruce Momjian wrote: > > > Brendan Jurd wrote: > > > > On 2/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > > Tom Lane wrote: > > > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > > > Peter Eisentraut w

Re: [PATCHES] SSL enhancement patch ver.2

2007-02-14 Thread Bruce Momjian
Victor B. Wagner wrote: > This patch adds following functionality to PostgreSQL > > 1. If PostgreSQL is compiled with OpenSSL version 0.9.7 and above, > both backend and libpq read site-wide OpenSSL configuration file as > described in OPENSSL_config functon manual page. > > This allows to use h

Re: [PATCHES] SSL enhancement patch ver.2

2007-02-14 Thread Bruce Momjian
Never mind, I found the answer: http://archives.postgresql.org/pgsql-hackers/2006-08/msg01931.php Working on the patch now. --- Bruce Momjian wrote: > Victor B. Wagner wrote: > > This patch adds following functiona

Re: [PATCHES] patch adding new regexp functions

2007-02-14 Thread Jeremy Drake
What was the status of this? Was there anything else I needed to do with this patch, or is it ready to be applied? Let me know if there is anything else I need to do on this... -- What this country needs is a good five cent nickel. ---(end of broadcast)-

[PATCHES] Autovacuum launcher

2007-02-14 Thread Alvaro Herrera
[resending, with the patch gzipped, as the previous one seems to be lost -- I mistakenly sent it to -hackers instead of -patches] Hi, Here's the autovacuum launcher patch I'm considering for inclusion. Possibly controversial stuff: 1. I changed InitPostgres to be able to get a database by OID.

Re: [PATCHES] patch adding new regexp functions

2007-02-14 Thread Bruce Momjian
Jeremy Drake wrote: > What was the status of this? Was there anything else I needed to do with > this patch, or is it ready to be applied? Let me know if there is > anything else I need to do on this... I assume it is ready for application. -- Bruce Momjian <[EMAIL PROTECTED]> http

Re: [PATCHES] Autovacuum launcher

2007-02-14 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Here's the autovacuum launcher patch I'm considering for inclusion. This part is very seriously broken: diff -c -p -r1.33 lwlock.h *** src/include/storage/lwlock.h5 Jan 2007 22:19:58 - 1.33 --- src/include/storage/lwlock.h13 F

Re: [PATCHES] patch adding new regexp functions

2007-02-14 Thread Neil Conway
On Wed, 2007-02-14 at 16:49 -0800, Jeremy Drake wrote: > What was the status of this? Was there anything else I needed to do with > this patch, or is it ready to be applied? Let me know if there is > anything else I need to do on this... Will do -- I'm planning to apply this as soon as I have th