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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Wed, 26 Jan 2005 16:59:19 -0500
  • Message-id: <20518(dot)1106776759(at)sss(dot)pgh(dot)pa(dot)us>

"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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group