Re: [HACKERS] WITH RECURSIVE patch V0.1

2008-05-18 Thread Gregory Stark
This is indeed really cool. I'm sorry I haven't gotten to doing what I promised in this area but I'm glad it's happening anyways. "Zoltan Boszormenyi" <[EMAIL PROTECTED]> writes: > Can we get the rows in tree order, please? >... > After all, I didn't specify any ORDER BY clauses in the base, r

Re: [HACKERS] WITH RECURSIVE patch V0.1

2008-05-18 Thread Gregory Stark
"David Fetter" <[EMAIL PROTECTED]> writes: > On Mon, May 19, 2008 at 12:21:20AM -0400, Gregory Stark wrote: >> "Zoltan Boszormenyi" <[EMAIL PROTECTED]> writes: >> > Also, it seems there are no infinite recursion detection: >> > >> > # with recursive x(level, parent, child) as ( >> >select 1::i

Re: [HACKERS] New DTrace probes proposal

2008-05-18 Thread Robert Treat
On Sunday 18 May 2008 03:18:13 Greg Smith wrote: > On Sat, 17 May 2008, Robert Lor wrote: > > I'd like to propose adding the following probes (some of which came from > > Simon) to 8.4. > > There's also a big DTrace probe set patch available from OmniTI: > https://labs.omniti.com/project-dtrace/tru

Re: [HACKERS] WITH RECURSIVE patch V0.1

2008-05-18 Thread David Fetter
On Mon, May 19, 2008 at 12:21:20AM -0400, Gregory Stark wrote: > "Zoltan Boszormenyi" <[EMAIL PROTECTED]> writes: > > Also, it seems there are no infinite recursion detection: > > > > # with recursive x(level, parent, child) as ( > >select 1::integer, * from test_connect_by where parent is null

Re: [HACKERS] Link requirements creep

2008-05-18 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I've been testing a new patch and do not see the problem on Fedora 8, >> so at least that platform's readline seems to be fixed. > It broke my FC6 box :-( Yeah, I saw. I'm inclined to wait a day to get a handle on the scope of the p

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

2008-05-18 Thread Mark Mielke
Merlin Moncure wrote: On Sun, May 18, 2008 at 5:22 PM, Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote: Can we get the rows in tree order, please? I.e. something like this: Is ordering by tree order defined in the standard when no explicit order is given? If not, it probably returns them

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

2008-05-18 Thread Merlin Moncure
On Sun, May 18, 2008 at 5:22 PM, Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote: > Can we get the rows in tree order, please? I.e. something like this: Is ordering by tree order defined in the standard when no explicit order is given? If not, it probably returns them in the order they are pulled up

Re: [HACKERS] Link requirements creep

2008-05-18 Thread Andrew Dunstan
Tom Lane wrote: I've been testing a new patch and do not see the problem on Fedora 8, so at least that platform's readline seems to be fixed. I find the hack Martijn proposes in the above message to be pretty ugly, so what I'm inclined to do is leave that out for now and see what failures we g

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

2008-05-18 Thread Zoltan Boszormenyi
David Fetter írta: On Sun, May 18, 2008 at 08:51:29PM +0900, Tatsuo Ishii wrote: WITH RECURSIVE patch V0.1 Here are patches to implement WITH RECURSIVE clause. There are some limitiations and TODO items(see the "Current limitations" section below). Comments are welcome. 1. Credit These pat

Re: [HACKERS] odd output in restore mode

2008-05-18 Thread Dave Page
On Sun, May 18, 2008 at 1:38 PM, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > I don't know how you tested, Copy a large file across a relatively slow network, and check the size on the destination drive before it finishes. > but could you please repeat the test with > GnuWin32's cp.exe? If it do

Re: [HACKERS] New DTrace probes proposal

2008-05-18 Thread Robert Lor
Greg Smith wrote: There's also a big DTrace probe set patch available from OmniTI: https://labs.omniti.com/project-dtrace/trunk/postgresql/ http://labs.omniti.com/trac/project-dtrace/wiki/Applications#PostgreSQL I don't know if you've looked at that before. There's some overlap but many uniq

[HACKERS] ERRORDATA_STACK_SIZE panic crashes on Windows

2008-05-18 Thread Tom Lane
Have any Windows-using hackers tried to look into the reports of $SUBJECT on 8.3? We have two fresh reports: http://archives.postgresql.org/pgsql-bugs/2008-05/msg00106.php http://archives.postgresql.org/pgsql-bugs/2008-05/msg00109.php and this isn't the first time we've heard of it. I spent some

Re: [HACKERS] notification information functions

2008-05-18 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: I suggest: pg_listened_events(out event name) returns setof record pg_pending_events(out event name, out message text) returns setof record The first would show events being listened on by the current backend,

Re: [HACKERS] notification information functions

2008-05-18 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > I suggest: > pg_listened_events(out event name) returns setof record > pg_pending_events(out event name, out message text) returns setof record > The first would show events being listened on by the current backend, > while the second would show all

[HACKERS] notification information functions

2008-05-18 Thread Andrew Dunstan
I am working on moving the notification buffer into shared memory as previously discussed. Since pg_listener will no longer exist, I think we need to provide a couple of information functions. I suggest: pg_listened_events(out event name) returns setof record pg_pending_events(out event nam

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

2008-05-18 Thread David Fetter
On Sun, May 18, 2008 at 08:51:29PM +0900, Tatsuo Ishii wrote: > WITH RECURSIVE patch V0.1 > > Here are patches to implement WITH RECURSIVE clause. There are some > limitiations and TODO items(see the "Current limitations" section > below). Comments are welcome. > > 1. Credit > > These patches we

Re: [HACKERS] ignore $PostgreSQL lines in regression tests?

2008-05-18 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Recently while adding $PostgreSQL markers to a bunch of .c and .h files I ran into trouble with the ecpg regression tests and had to revert the change for a handful of files. However, it occurred to me that we could have pg_regres

Re: [HACKERS] ignore $PostgreSQL lines in regression tests?

2008-05-18 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Recently while adding $PostgreSQL markers to a bunch of .c and .h files > I ran into trouble with the ecpg regression tests and had to revert the > change for a handful of files. However, it occurred to me that we could > have pg_regress tell diff to

[HACKERS] ignore $PostgreSQL lines in regression tests?

2008-05-18 Thread Andrew Dunstan
Recently while adding $PostgreSQL markers to a bunch of .c and .h files I ran into trouble with the ecpg regression tests and had to revert the change for a handful of files. However, it occurred to me that we could have pg_regress tell diff to ignore such lines, by passing it the arguments "

Re: [HACKERS] Can't t compile current HEAD

2008-05-18 Thread Greg Smith
On Thu, 15 May 2008, Nikhils wrote: On Thu, May 15, 2008 at 11:59 AM, Pavel Stehule <[EMAIL PROTECTED]> wrote: I always use a ~/.cvsrc containing My .cvsrc also includes: Good hints, and there's now a little section including them all at http://wiki.postgresql.org/wiki/Working_with_CVS#Init

Re: [HACKERS] odd output in restore mode

2008-05-18 Thread Andrew Dunstan
Dave Page wrote: On Tue, May 13, 2008 at 5:11 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Andrew Dunstan wrote: > I would be very surprised if xcopy did not exhibit the same > preallocating behaviour as copy. I, on the other hand, would not say anything until someone tried it, and t

Re: [HACKERS] New DTrace probes proposal

2008-05-18 Thread Greg Smith
On Sat, 17 May 2008, Robert Lor wrote: I'd like to propose adding the following probes (some of which came from Simon) to 8.4. There's also a big DTrace probe set patch available from OmniTI: https://labs.omniti.com/project-dtrace/trunk/postgresql/ http://labs.omniti.com/trac/project-dtrace/