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

2008-07-07 Thread Yoshiyuki Asaba
, -- Yoshiyuki Asaba [EMAIL PROTECTED] if i am not totally wrong, this should give us a different result. i am looking forward to see this patch in core :). it is simply wonderful ... many thanks, hans On Jul 3, 2008, at 1:11 AM, David Fetter wrote

Re: [HACKERS] Git Repository for WITH RECURSIVE and others

2008-07-02 Thread Yoshiyuki Asaba
'git://git.postgresql.org/git/~davidfetter/postgresql/.git' failed. I ran git-update-server-info on the server, and it should work now. :) I cannot get yet... % cat ~/.gitconfig [user] name = Yoshiyuki Asaba email = [EMAIL PROTECTED] # WITH RECURSIVE repository

Re: [HACKERS] Git Repository for WITH RECURSIVE and others

2008-07-02 Thread Yoshiyuki Asaba
not). Thanks for the advice. I could get the repository via HTTP. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Git Repository for WITH RECURSIVE and others

2008-06-24 Thread Yoshiyuki Asaba
/git/~davidfetter/postgresql/.git' failed. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

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

2008-05-24 Thread Yoshiyuki Asaba
{18,7} | 18-7 {26,13} | 26-13 {26,1} | 26-1 {26,12} | 26-12 {38,6} | 38-6 {38,17,9} | 38-17-9 {38,17,8} | 38-17-8 {38,15,10} | 38-15-10 {38,15,5,2} | 38-15-5-2 {38,15,5,3} | 38-15-5-3 (11 rows) Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql

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

2008-05-23 Thread Yoshiyuki Asaba
; count --- 100 (1 row) Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

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

2008-05-23 Thread Yoshiyuki Asaba
; if (tuplestore_gettupleslot(node-ss.ps.state-es_tuplestorestate, true, slot)) return slot; Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

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

2008-05-21 Thread Yoshiyuki Asaba
? Couldn't we just have it pay attention to the existing max_stack_depth? Recursive query does not consume stack. The server enters an infinite loop without consuming stack. Stack-depth error does not happen. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list

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

2008-05-19 Thread Yoshiyuki Asaba
to deal with infinite streams of records. I think it's the other way around. The server should not emit infinite number of records. How about adding new GUC parameter max_recursive_call? Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] ts_headline() dumps core

2008-01-15 Thread Yoshiyuki Asaba
) at postmaster.c:1029 #21 0x081be07b in main (argc=1, argv=0x8456070) at main.c:188 - Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] initdb failed on Windows 2000

2007-08-31 Thread Yoshiyuki Asaba
Hi, From: Magnus Hagander [EMAIL PROTECTED] Subject: Re: [HACKERS] initdb failed on Windows 2000 Date: Thu, 30 Aug 2007 10:14:45 +0200 On Wed, Aug 29, 2007 at 08:57:55AM -0400, Andrew Dunstan wrote: Yoshiyuki Asaba wrote: I have compiled PostgreSQL 8.2.4 with MinGW on Windows

Re: [HACKERS] initdb failed on Windows 2000

2007-08-29 Thread Yoshiyuki Asaba
Hi, From: Yoshiyuki Asaba [EMAIL PROTECTED] Subject: [HACKERS] initdb failed on Windows 2000 Date: Mon, 27 Aug 2007 20:46:35 +0900 (JST) I have compiled PostgreSQL 8.2.4 with MinGW on Windows 2000. Then I have executed initdb as Administrator. However initdb failed with the following message

Re: [HACKERS] initdb failed on Windows 2000

2007-08-29 Thread Yoshiyuki Asaba
we're just being consistent. In fact, we're being more liberal on Windows than on Unix because we make some provision for the restricted token gadget. Administrator can run initdb on Windows XP, Server 2003 and Vista. Is this right? -- Yoshiyuki Asaba [EMAIL PROTECTED

[HACKERS] initdb failed on Windows 2000

2007-08-27 Thread Yoshiyuki Asaba
, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] pg_restore fails with a custom backup file

2007-02-17 Thread Yoshiyuki Asaba
From: Magnus Hagander [EMAIL PROTECTED] Subject: Re: [HACKERS] pg_restore fails with a custom backup file Date: Fri, 16 Feb 2007 10:13:35 +0100 On Fri, Feb 16, 2007 at 02:09:41PM +0900, Yoshiyuki Asaba wrote: Does not compile on my MinGW - errors in the system headers (unistd.h, io.h

Re: [HACKERS] pg_restore fails with a custom backup file

2007-02-15 Thread Yoshiyuki Asaba
]: *** [pg_dump] Error 1 $ uname -sr MINGW32_NT-5.1 1.0.10(0.46/3/2) Is MINGW version too old? -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [HACKERS] pg_restore fails with a custom backup file

2006-12-19 Thread Yoshiyuki Asaba
/pg_restore with the attached patch. -- Yoshiyuki Asaba [EMAIL PROTECTED] Index: src/include/c.h === RCS file: /projects/cvsroot/pgsql/src/include/c.h,v retrieving revision 1.214 diff -c -r1.214 c.h *** src/include/c.h 4 Oct 2006

[HACKERS] pg_restore fails with a custom backup file

2006-12-14 Thread Yoshiyuki Asaba
() and ftello(). So I think it limit to handle a 2GB file. Is this a specification? Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-28 Thread Yoshiyuki Asaba
, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-28 Thread Yoshiyuki Asaba
From: Tom Lane [EMAIL PROTECTED] Subject: Re: [HACKERS] SO_SNDBUF size is small on win32? Date: Wed, 28 Jun 2006 09:54:21 -0400 Yoshiyuki Asaba [EMAIL PROTECTED] writes: I think libpq interface does not use non-blocking socket. Not unless the Windows port has also disabled pg_set_noblock

[HACKERS] SO_SNDBUF size is small on win32?

2006-06-27 Thread Yoshiyuki Asaba
, I think we should increase SO_SNDBUF to more than 8192. I attache the patch. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] Index: pqcomm.c === RCS file: /projects/cvsroot/pgsql/src/backend/libpq/pqcomm.c,v retrieving revision 1.184

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-27 Thread Yoshiyuki Asaba
From: Tom Lane [EMAIL PROTECTED] Subject: Re: [HACKERS] SO_SNDBUF size is small on win32? Date: Tue, 27 Jun 2006 11:30:56 -0400 Yoshiyuki Asaba [EMAIL PROTECTED] writes: send() may take as long as 200ms. So, I think we should increase SO_SNDBUF to more than 8192. I attache the patch. Why

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-27 Thread Yoshiyuki Asaba
changed a client machine... Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-27 Thread Yoshiyuki Asaba
From: Tom Lane [EMAIL PROTECTED] Subject: Re: [HACKERS] SO_SNDBUF size is small on win32? Date: Tue, 27 Jun 2006 12:28:35 -0400 Andrew Dunstan [EMAIL PROTECTED] writes: Martijn van Oosterhout wrote: On Wed, Jun 28, 2006 at 12:23:13AM +0900, Yoshiyuki Asaba wrote: http

Re: [HACKERS] CVS HEAD busted on Windows?

2006-06-21 Thread Yoshiyuki Asaba
WIN32 + /* establish control-C handling for interactive operation */ + setup_cancel_handler(); + #endif + successResult = SendQuery(options.action_string) ? EXIT_SUCCESS : EXIT_FAILURE; } -- Yoshiyuki Asaba [EMAIL PROTECTED

Re: [HACKERS] pg_dump -Ft failed on Windows XP

2006-04-20 Thread Yoshiyuki Asaba
/_crt_tmpfile.asp -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[HACKERS] pg_dump -Ft failed on Windows XP

2006-04-19 Thread Yoshiyuki Asaba
(). Win32's tmpfile() creates the file into root folder. But non-administrator users can't create files into root folder. So, I think it fails that non-administrator users run pg_dump with -Ft option. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] ---(end of broadcast