Re: [PATCHES] WITH RECURSIVE patch V0.1

2008-05-23 Thread Yoshiyuki Asaba
Hi, From: David Fetter [EMAIL PROTECTED] Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1 Date: Sun, 18 May 2008 11:47:37 -0700 I tried a bunch of different queries, and so far, only these two haven't worked. Any ideas what I'm doing wrong here? WITH RECURSIVE t(n) AS ( SELECT 1

Re: [PATCHES] WITH RECURSIVE patch V0.1

2008-05-23 Thread David Fetter
On Sat, May 24, 2008 at 03:21:01AM +0900, Yoshiyuki Asaba wrote: Hi, From: David Fetter [EMAIL PROTECTED] Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1 Date: Sun, 18 May 2008 11:47:37 -0700 I tried a bunch of different queries, and so far, only these two haven't worked. Any ideas

Re: [PATCHES] WITH RECURSIVE patch V0.1

2008-05-23 Thread Yoshiyuki Asaba
Hi, From: David Fetter [EMAIL PROTECTED] Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1 Date: Fri, 23 May 2008 11:26:30 -0700 Where is the new patch? I will create the revised patch on June. This is a patch for this problem. *** ../../pgsql/src/backend/executor/nodeRecursivescan.c

Re: [HACKERS] [PATCHES] WITH RECURSIVE patch V0.1

2008-05-23 Thread David Fetter
On Sat, May 24, 2008 at 05:01:11AM +0900, Yoshiyuki Asaba wrote: Hi, From: David Fetter [EMAIL PROTECTED] Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1 Date: Fri, 23 May 2008 11:26:30 -0700 Where is the new patch? I will create the revised patch on June. This is a patch for this

[PATCHES] TODO item: Have psql show current values for a sequence

2008-05-23 Thread Dickson S. Guedes
Hi all, These patch implements the TODO item: Have psql show current values for a sequence. Comments are welcome. * Credits The original patch were developed by Euler Taveira de Oliveira [EMAIL PROTECTED] but how he is a little busy, he sends it to me and I made some changes to satisfy the TODO

Re: [PATCHES] \d+ should display the storage options for columns

2008-05-23 Thread Gregory Stark
Alvaro Herrera [EMAIL PROTECTED] writes: This seems to be against an older version of psql ... with the printTable API stuff, we reworked this -- in particular the mbvalidate() call that's only on WIN32 is gone (actually it's the lack of it that's gone.) Sorry. Here's a patch against a

Re: [PATCHES] \d+ should display the storage options for columns

2008-05-23 Thread Alvaro Herrera
Gregory Stark wrote: Alvaro Herrera [EMAIL PROTECTED] writes: This seems to be against an older version of psql ... with the printTable API stuff, we reworked this -- in particular the mbvalidate() call that's only on WIN32 is gone (actually it's the lack of it that's gone.) Sorry.

Re: [PATCHES] Extending grant insert on tables to sequences

2008-05-23 Thread Jaime Casanova
On Thu, May 22, 2008 at 1:18 PM, Jaime Casanova [EMAIL PROTECTED] wrote: Hi, The idea of this patch is to avoid the need to make explicit grants on sequences owned by tables. I've noted that the patch i attached is an older version that doesn't compile because of a typo... Re-attaching right

Re: [PATCHES] Extending grant insert on tables to sequences

2008-05-23 Thread Jaime Casanova
On Sat, May 24, 2008 at 12:09 AM, Alvaro Herrera [EMAIL PROTECTED] wrote: Please add the patch to the commitfest page, Ah! I forgot we have a new process now... patch added to the commitfest page... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel.

Re: [PATCHES] Extending grant insert on tables to sequences

2008-05-23 Thread Alvaro Herrera
Jaime Casanova escribió: On Thu, May 22, 2008 at 1:18 PM, Jaime Casanova [EMAIL PROTECTED] wrote: Hi, The idea of this patch is to avoid the need to make explicit grants on sequences owned by tables. I've noted that the patch i attached is an older version that doesn't compile

Re: [PATCHES] TODO item: Have psql show current values for a sequence

2008-05-23 Thread daveg
On Sat, May 24, 2008 at 12:27:16AM -0300, Dickson S. Guedes wrote: Hi all, These patch implements the TODO item: Have psql show current values for a sequence. Comments are welcome. Sequence public.foo_bar_seq +---+-+-+ |Column |