Skip site navigation (1) Skip section navigation (2)

Re: long sql "in" clause crashes server process (8.0 Release)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: long sql "in" clause crashes server process (8.0 Release)
Date: 2005-01-26 21:59:19
Message-ID: 20518.1106776759@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> On MingW, you add:
> -Wl,--stack=4194304
> to get 4Mb stack. At least the value increases in the header.

> And I can confirm that doing this fixes the problem and turns it into
> the error message about stack size. (But won't things crash again if I
> increase that one? Or will it increase the stack manually then?)

> Patch attached.

Applied.  Some googling confirmed that cygwin uses this switch too,
so I added it in that makefile branch as well.  The references I found
suggested a slightly different syntax: -Wl,--stack,4194304.  It's
likely that the "=" variant works fine on cygwin too, but just for
paranoia's sake I followed the references.

			regards, tom lane

In response to

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2005-01-27 17:38:58
Subject: why postgresql does not run as local sysetm.
Previous:From: Tom LaneDate: 2005-01-26 19:47:16
Subject: Re: Opening stdin/stdout in binary mode on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group