Markus Schiltknecht wrote: > Hi, > > One of our PostgreSQL 8.1.5 databases constantly crashed on a certain > query (backend SEGFAULTs). I've figured the crashes were caused by a > very long IN() clause. > > You can easily reproduce the crash by feeding the output of the python > script below to your database.
I'd argue that you have max_stack_depth set to an invalid value (higher than your true stack limit). I tried your example here on 8.1.5 and got this: alvherre=# \i foo CREATE TABLE psql:foo:2: ERROR: stack depth limit exceeded HINT: Increase the configuration parameter "max_stack_depth". DROP TABLE -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
