Re: [HACKERS] XML index support

2008-06-28 Thread Jean-Michel Pouré
Thank you all for these kind answers. Cheers, JMP -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Reini Urban
Dave Page schrieb: On Tue, Jun 24, 2008 at 9:32 AM, Magnus Hagander [EMAIL PROTECTED] wrote: Yes. As in the cygwin build does build. Nobody really has verified if the fix is needed there. But frankly, if you are likely to care about the effects of this issue, you won't be running cygwin

[HACKERS] interval madness ...

2008-06-28 Thread Hans-Juergen Schoenig
hello everybody ... i am sitting here in a training and i am wondering about the following issue ... test=# select now() + '3 years 2 decades 4000 seconds 9 minutes'::interval; ?column? --- 2031-06-28 11:58:35.052423+02 (1 row) test=# select now()

Re: [HACKERS] interval madness ...

2008-06-28 Thread Gregory Stark
Hans-Juergen Schoenig [EMAIL PROTECTED] writes: why do i get a different timezone just because of adding one more century? i cannot see an obvious reason. What version of Postgres and what setting of TZ? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] interval madness ...

2008-06-28 Thread Gregory Stark
Hans-Juergen Schoenig [EMAIL PROTECTED] writes: why do i get a different timezone just because of adding one more century? i cannot see an obvious reason. This thread may be enlightening: http://archives.postgresql.org/pgsql-patches/2007-09/msg00292.php I can't find the message for the

Re: [HACKERS] interval madness ...

2008-06-28 Thread Hans-Juergen Schoenig
On Jun 28, 2008, at 11:39 AM, Gregory Stark wrote: Hans-Juergen Schoenig [EMAIL PROTECTED] writes: why do i get a different timezone just because of adding one more century? i cannot see an obvious reason. What version of Postgres and what setting of TZ? -- Gregory Stark

Re: [HACKERS] Posting to hackers and patches lists

2008-06-28 Thread Marko Kreen
On 5/7/08, Tom Lane [EMAIL PROTECTED] wrote: Matthew T. O'connor [EMAIL PROTECTED] writes: By the way, what is the actual size limit on hackers vs patches. They do have different size limits; we'd have to raise the limit on -hackers if we do this. Marc would know exactly what the limits

Re: [HACKERS] Posting to hackers and patches lists

2008-06-28 Thread Marc G. Fournier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try now, just raised it to the same as -patches (100k) ... - --On Saturday, June 28, 2008 12:59:18 +0300 Marko Kreen [EMAIL PROTECTED] wrote: On 5/7/08, Tom Lane [EMAIL PROTECTED] wrote: Matthew T. O'connor [EMAIL PROTECTED] writes: By the

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Magnus Hagander
Reini Urban wrote: Dave Page schrieb: On Tue, Jun 24, 2008 at 9:32 AM, Magnus Hagander [EMAIL PROTECTED] wrote: Yes. As in the cygwin build does build. Nobody really has verified if the fix is needed there. But frankly, if you are likely to care about the effects of this issue, you won't

Re: [HACKERS] ecpg generated files ignorable?

2008-06-28 Thread Magnus Hagander
Alvaro Herrera wrote: Michael Meskes wrote: Well, in my source tree I have two, one for MS VC++ and one for Borland C++ Builder. And yes, I can build a third one for MS VC++ as well by just issuing the corresponding make call. However, I have no idea whether we need both, the only differ in

[HACKERS] [patch] plproxy v2

2008-06-28 Thread Marko Kreen
We have written a FAQ, where are common issues collected, there are also discussion about design decisions and why concentrating only to functions is good idea. http://plproxy.projects.postgresql.org/faq/faq.html The patch itself is attached, and also made available here:

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Alvaro Herrera
Magnus Hagander wrote: 8.3.x not because the new SSPI doesn't work yet. current cygwin patch in testing is attached. I assume this is a WIP and not actually for application, right? Please look it over because it contains a number of pure-whitespace changes that make it harder to read,

Re: [HACKERS] interval madness ...

2008-06-28 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Hans-Juergen Schoenig [EMAIL PROTECTED] writes: why do i get a different timezone just because of adding one more century? i cannot see an obvious reason. This thread may be enlightening:

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Reini Urban
Magnus Hagander schrieb: Reini Urban wrote: Dave Page schrieb: On Tue, Jun 24, 2008 at 9:32 AM, Magnus Hagander [EMAIL PROTECTED] wrote: Yes. As in the cygwin build does build. Nobody really has verified if the fix is needed there. But frankly, if you are likely to care about the effects of

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Andrew Dunstan
Magnus Hagander wrote: Heh. Maybe not dead, but certainly not really alive either ;-) Given the evidence in your patch that clearly 8.3 isn't quite up to speed on cygwin, and nobody has really noticed until now. AIUI, only the gssapi stuff is broken. Most users are not likely to want it

Re: [HACKERS] stat() vs cygwin

2008-06-28 Thread Reini Urban
Andrew Dunstan schrieb: Magnus Hagander wrote: Heh. Maybe not dead, but certainly not really alive either ;-) Given the evidence in your patch that clearly 8.3 isn't quite up to speed on cygwin, and nobody has really noticed until now. AIUI, only the gssapi stuff is broken. Most users are

Re: [HACKERS] Git Repository for WITH RECURSIVE and others

2008-06-28 Thread David Fetter
On Tue, Jun 24, 2008 at 10:27:28PM +0200, Magnus Hagander wrote: Now, if you can give us a step-by-step on how to set it up, that would certainly help ;-) Gitosis does not, as far as I can tell, have that delegation capability, but I've come up with a way to do this: 1. Use git-shell.

[HACKERS] Buildfarm client code 3.1 released

2008-06-28 Thread Andrew Dunstan
I have just released version 3.1 of the buildfarm client code, which includes a fix for a perl quoting bug made 15 months ago that probably accounts for some odd failures we have been seeing. See http://pgfoundry.org/frs/?group_id=140 to download. All users are strongly recommended to