Re: [PATCHES] [HACKERS] WITH RECURSIVE updated to CVS TIP

2008-07-17 Thread Tatsuo Ishii
On Wed, Jul 16, 2008 at 01:57:04PM +0900, Tatsuo Ishii wrote: No idea. What do you think if we allow only one query name at the moment. I'm not sure I understand what that has to do with sorting. Please find attached a place where I've found some problems sorting by tree

[PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread Tatsuo Ishii
Hi, Here is the lastest WITH RECURSIVE patches against CVS HEAD created by Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. (David Fetter's psql help patches are not included. It seems his git repository has gone). This version implements: - detect certain queries those are not valid

Re: [PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread David Fetter
On Thu, Jul 17, 2008 at 06:40:25PM +0900, Tatsuo Ishii wrote: Hi, Here is the lastest WITH RECURSIVE patches against CVS HEAD created by Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. I tried this patch vs. CVS HEAD used my usual configure option with only --with-prefix set, then

Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Alvaro Herrera
Simon Riggs wrote: Is autovacuum doing a wraparound-avoiding VACUUM? Currently, no easy way to tell. Patch to change message of autovac in pg_stat_activity when we are performing an anti-wraparound VACUUM. I just obsoleted this patch. The new patch should be easier to do though -- just a

Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Simon Riggs
On Thu, 2008-07-17 at 17:10 -0400, Alvaro Herrera wrote: Simon Riggs wrote: Is autovacuum doing a wraparound-avoiding VACUUM? Currently, no easy way to tell. Patch to change message of autovac in pg_stat_activity when we are performing an anti-wraparound VACUUM. I just obsoleted

Re: [PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread Tatsuo Ishii
Here is the lastest WITH RECURSIVE patches against CVS HEAD created by Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. I tried this patch vs. CVS HEAD used my usual configure option with only --with-prefix set, then tried to make, and got: make[3]: *** No rule to make target

Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Thu, 2008-07-17 at 17:10 -0400, Alvaro Herrera wrote: I don't like your wording though; it feels too verbose (and you're losing the ANALYZE in case it's doing both things). How about snprintf(activity, MAX_AUTOVAC_ACTIV_LEN, autovacuum: VACUUM%s%s,