Re: [PATCHES] [HACKERS] WITH RECURSIVE patches 0818

2008-08-22 Thread Tatsuo Ishii
> > Here is new patches fixing the bug you pointed out (patches was > > created by Yoshiyuki). Also I added your SQL to the regression test, > > and now the patches is against CVS HEAD. For your convenience I also > > include patches against the previous version. > > Thanks :) > > Any progress on

Re: [PATCHES] [HACKERS] WITH RECURSIVE patches 0818

2008-08-22 Thread David Fetter
On Sat, Aug 23, 2008 at 11:33:13AM +0900, Tatsuo Ishii wrote: > > I think I may have found another bug: > > > > WITH RECURSIVE t(i,j) AS ( > > VALUES (1,2) > > UNION ALL > > SELECT t2.i, t.j > > FROM ( > > SELECT 2 AS i > > UNION ALL /* Wrongly getting detecte

Re: [PATCHES] review: table function support

2008-08-22 Thread Bruce Momjian
bruce wrote: > > Added to September commit fest. Ah, already applied, removed. > --- > > Pavel Stehule wrote: > > 2008/7/10 Marko Kreen <[EMAIL PROTECTED]>: > > > On 7/10/08, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > >>

Re: [PATCHES] review: table function support

2008-08-22 Thread Bruce Momjian
Added to September commit fest. --- Pavel Stehule wrote: > 2008/7/10 Marko Kreen <[EMAIL PROTECTED]>: > > On 7/10/08, Pavel Stehule <[EMAIL PROTECTED]> wrote: > >> I am sending actualized patch > >> > >> Regards > >> Pave

Re: [PATCHES] [HACKERS] WITH RECURSIVE patches 0818

2008-08-22 Thread Tatsuo Ishii
> I think I may have found another bug: > > WITH RECURSIVE t(i,j) AS ( > VALUES (1,2) > UNION ALL > SELECT t2.i, t.j > FROM ( > SELECT 2 AS i > UNION ALL /* Wrongly getting detected, I think */ > SELECT 3 AS i > ) AS t2 > JOIN > t >

Re: [PATCHES] [HACKERS] Userset logging

2008-08-22 Thread Bruce Momjian
Simon Riggs wrote: > > On Mon, 2008-07-07 at 16:13 +0100, Simon Riggs wrote: > > I notice log_temp_files is a PGC_USERSET parameter, which is out of step > > with our current thinking on who is allowed to initiate logging. > > > > Is there a rationale for this? Or should we set this to PGC_SUSET

Re: [PATCHES] pgbench minor fixes

2008-08-22 Thread Bruce Momjian
Committed, commit fest page updated. --- Simon Riggs wrote: > Minor patch on pgbench > > 1. -i option should run vacuum analyze only on pgbench tables, not *all* > tables in database. > > 2. pre-run cleanup step was DELETE

[PATCHES] Re: [HACKERS] Solaris ident authentication using unix domain sockets

2008-08-22 Thread Bruce Momjian
Garick Hamlin wrote: > On Thu, Jul 03, 2008 at 02:01:22PM -0400, Tom Lane wrote: > > Garick Hamlin <[EMAIL PROTECTED]> writes: > > > I have a patch that I have been using to support postgresql's > > > notion of ident authentication when using unix domain sockets on > > > Solaris. This patch