HERE n < 50)
SELECT * FROM t;
This optimization is in qual_is_pushdown_safe(). So, I've fixed not to
optimize WITH-clause in the function.
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
>
> if i am not totally wrong, this should give us a different result.
://..." apparently doesn't work on that repository (I don't
> know why 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
Git repository in /home/y-asaba/x/postgresql/.git/
> > fatal: The remote end hung up unexpectedly
> > fetch-pack from
> > 'git://git.postgresql.org/git/~davidfetter/postgresql/.git' failed.
>
> I ran git-update-server-info on the server, and it should work now
dly
fetch-pack from 'git://git.postgresql.org/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
T EXISTS (SELECT 1 FROM test_connect_by WHERE parent =
x.child);
path | array_to_string
-+-
{18,11} | 18->11
{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} |
}
! slot = node->ss.ss_ScanTupleSlot;
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
ION ALL
SELECT n+1
FROM t
WHERE n < 100
)
SELECT count(*) FROM t;
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
; > How about adding new GUC parameter "max_recursive_call"?
>
> 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.
and waits ...
> >>
> >
> > Well, psql might wait and wait but it's actually receiving rows. A cleverer
> > client should be able to deal with infinite streams of records.
> >
>
> I think it's the other way around. The server shoul
c918) at postmaster.c:2830
#19 0x0821ab22 in ServerLoop () at postmaster.c:1274
#20 0x0821a52f in PostmasterMain (argc=1, argv=0x8456070) 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
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:
> > >
> &g
27;t let you run initdb as
> root on Unix, so 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 Vi
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
.exe on Windows
2000?
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
patch, I can dump and
> restore a table at the end of a 10gb database without errors.
I tried the attached patch. But I got the following error.
pg_backup_archiver.o(.text+0x1fa4): In function `allocAH':
C:/msys/1.0/home/y-asaba/postgresql-8.2.3-patch/src/bin/pg_dump/pg_backup_archiver.
ell()/fseek()?
fpos_t is a 8byte type. I tested pg_dump/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
eko() 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
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 Win
, buf, len, flags)
I think this is only server-side problem. Is this right?
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
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, Yos
-> about 3sec.
However, this problem did not occur when I changed a client
machine...
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
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 mo
s. So, 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
***
*** 303,308
--- 303,313
if (VariableEquals(pset.vars, "ECHO", "all"))
puts(options.action_string);
+ #ifdef 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]
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_tmpfile.asp
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
file() in pg_backup_tar.c:tarOpen(). 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]
-
27 matches
Mail list logo