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.

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

[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 TOD

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

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.

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

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 C

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

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" > +---+-+-+ > |Col